Query running total by category between dates

[foshizzle]

I thought this would be easier but I'm trying to obtain a total of all fuel issued and fuel received by airline between any two dates.
Can anyone help?

SELECT tblTransactions.TransactionID, tblTransactions.TransactionDate, tblTransactions.AirlineCompanyLookup, tblTransactions.GallonsIssued, tblTransactions.GallonsReceived
FROM tblTransactions;

 

[theDBguy]

Have you tried using a Totals query? Just curious...

 

[foshizzle]

Have you tried using a Totals query? Just curious...

I must be doing something wrong.

 

[theDBguy]

I must be doing something wrong.
View attachment 85446

If you want to group the transactions by date, remove the TransactionID from your query and try it again.

 

[foshizzle]

If you want to group the transactions by date, remove the TransactionID from your query and try it again.

Lol ok where's that easy button?? Thanks!

 

[theDBguy]

Lol ok where's that easy button?? Thanks!

No worries. Glad to hear you got it sorted out. Good luck with your project.