Group by currency ranges

[morlan]

Hi,

I want to run a query that will count and group records into specified income brackets. Similar to the age bracket query here:

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=51077

Here is the table in question:

tblMain

ID ------ Income

101 ----- £12,000
102 ----- £24,000
103 ----- £36,000
104 ----- £38,000
105 ----- £32,000

Here's how the query should look

Query result

Income -------------------Count

£12,000 - £30,000---------- 2
£30,001 - £40,000---------- 3


Thanks in adv.

 

[dcx693]

That query technique should work just fine for what you have. Just make it into a totals query, grouped by income ranges, counting over the ID field.