Grouping Totals

[whitestone]

Hello All,

I have a database which contains information about Legacy donations given to my charity. I am currently running research on this data.

What I want to know is whether I can run a query (or any other tool) which will enable me to see how many donors gave whithin certain groups of amount. For example, how many gave between £100 and £1000, £1001 and £5000, £5000 and £10000 etc. Each donor has a unique reference number which I could use to run a count but I don't know how to set up a query to group the data like this.

help

Ben

 

[jeremie_ingram]

You could use a criteria expression within the query. It would be Between # and # . If you would like to be prompted for the range that is returned, put this in the criteria field Between [Lowest Amt] and [Highest Amt]

 

[IgorB]

Query:

SELECT DonorID, Count(DonorId) AS TotalDonors
FROM YourTableName
WHERE YourMoney between 1 and 1000
GROUP BY DonorID

Igor

Best regards from Russia.

 

[Pat Hartman]

If you are using a newer version of Access, try the Partition() function. Otherwise, write your own.