Soring in a Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top