You'll see in the dropdown for Molsen night that it lists two items for the
same. One red and one yellow. This is because only one of the pictures from
the photo table has the red as its special color, thus the query groups by
that one, and then the blank ones. Of course, I could solve this by setting
the color for all of them as red and it would group into one, but thats too
hard to do!
"Jordan Marton" <JMartonHAHAmarketaxess.com> wrote in message
news:beh3t8$8tc$1forums.macromedia.com...so> I have a table in a database that contains all my photos. The fields are
> like Name, SRC, GalleryName, DateAdded, SpecialStyle. The only one you may
> be confused about is Special Style. I include that field in my databasesthat> I can overrid some CSS settings for particular items.
> To display a listing of the galleries (to then go on and select a specific
> picture) I had a query that just finds all the distinct gallery names from
> the Photo table. I have also set that query to group by SpecialStyle soquery,> listing will show up as red for example. Is it possible, through thequery?> or some other access technique to get color: red into the query called
> GalleryListings, or to update all the photos with that particular gallery
> with that in their specialstyle item so it then groups by that in the>