how to substract total of groups

[spooky30]

i have three fields in query

Transaction types-grouped
transaction date-condition requiring current date
Transaction amount- sum

when i run the query it gives me sum of amount under each head( grouped)
date wise

eg total of reciept and payment groups in each date

how can i calculate diffrences of each group on given date to find cash balance on each date

ie reciept group - payment group for each date

 

[Brianwarnock]

If you want to do this in 1 query then group on date and sum
IIf(trantype="pay",[amount]*-1,[amount]) or whatever the fields and codes are.

If you wish to keep the original query then take it into another query twice joining on date and selecting receits from 1 and payments from the other and doing your subtracting.

Brian