grouping query

[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???

 

[Jeff Boyce]

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>

 

[[MVP] S. Clark]

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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-