Soring in a Query

[Guest]

I am querying a table with 380K records and 40 fields. I am wanting to use
two of those fields (Example: Style and Color) for grouping, so that those
like fileds are together. However, I have a data field (in the talbe) that I
would like to put into my query, but when I insert the date the query does
not keep my (Style, Color) toegther? Any ideas? I did try a "where"
expression in my date field, however when I do this I can not see the
dates... and I must see the dates in order to complete an analysis of sales
for each style color.

TFTH,
Tom

 

[Guest]

The query sorts by the field to the left most. If this did not answer how
then post your SQL so it can be edited for you.