query grouping

[Penny]

How do you design a query and group according to one
field? example--you have in the fields--
Price Price Weight/Size
Product Product Product
Minprice MaxPrice


How would you set it up to where you could group the query
by the weight/size?

 

[Jeff Boyce]

Penny

Use a "Totals" query, grouping by the field of interest.

This is probably more suitable to the .queries newsgroup.

Good luck

Jeff Boyce
<Access MVP>

 

[Tim Ferguson]

How would you set it up to where you could group the query
by the weight/size?

Use a GROUP BY clause?

Remember that grouping by numerics will work only if the numbers match
exactly.

Hope that helps


Tim F