Create Query Showing Totals By Price Band

[chris-evans]

Hi I have a table listing all transactions and there are hundreds of thousands of rows (each row represents a transaction). What i'd like to do is create a query that summarises the total of transactions by buckets of values e.g.

<$10
>$10 and <$25
>$50

etc. Any guidance on how to do this would be appreciated.

Thanks

Chris

 

[alansidman]

Create three queries

SELECT Sheet1.ID1, Sheet1.Amount
FROM Sheet1
WHERE (((Sheet1.Amount)<10));


SELECT Sheet1.ID1, Sheet1.Amount
FROM Sheet1
WHERE (((Sheet1.Amount) Between 10 And 24));


SELECT Sheet1.ID1, Sheet1.Amount
FROM Sheet1
WHERE (((Sheet1.Amount)>25));


With each one open in datasheet view, click on the Sigma (looks like a large E) Symbol and then select Sum in the drop down on the data sheet.