grouping query

  • Thread starter Thread starter Penny
  • Start date Start date
P

Penny

Here is what my query looks like--(sort of)
Price Price Weight/Size
Product Product Product
MinPrice MaxPrice

How would I group this info according to the weight/size???
 
Penny

Already answered in .tablesdbdesign. Newsgroup protocol asks that you not
post separately to 'groups. Instead, select as many groups as are
appropriate (usually only one) in the "To:" -- this will allow a response in
one newsgroup to show in the others to which the question was posted.

Good luck

Jeff Boyce
<Access MVP>
 
I don't understand. Are there 8 columns or 3 in the result of the query.

Typically, to Group something, you would use the GROUP BY operator.

i.e.
Select Category, Count(Value) from tablename
Group By Category

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top