group by a range of values

[therzakid]

Hello, I've created a database that tracks all the sales. I now want to look at how many sales occur in certain price bands. I've created a query for this but haven't been able to group the sales prices together e.g. 0 to 500, 500 to 650, etc... Thanks for any advice or suggestions you might have!

[alansidman]

In your sales field criteria in your query, type between 0 and 500. This will give you all sales from zero to 500. Change accordingly.

Alan

[rpeare]

you could also create a label (if you're attempting to look at the sales totals for different price brackets by adding a totals line to your query and building your own label something like:

iif(SalesTotal < 500, "Under 500", iif(SalesTotal < 1000, "500 - 1000","Over 1000"))

[alansidman]

After seeing rpeare's suggestion it brought another idea to mind. You could set up a range of categories as rpeare suggested and create a cross tab query.

If you have not set up a cross tab query, here is a quick video on how to do it.

http://www.datapigtechnologies.com/f.../crosstab.html



Alan