query grouping

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

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?
 
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>
 
How would you set it up to where you could group the query
by the weight/size?
Click to expand...

Use a GROUP BY clause?

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

Hope that helps


Tim F
 
Back
Top