Query running total by category between dates (1 Viewer)

foshizzle

Registered User.
Local time
Today, 07:16
Joined
Nov 27, 2013
Messages
277
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?

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

theDBguy

I’m here to help
Staff member
Local time
Today, 04:16
Joined
Oct 29, 2018
Messages
21,357
Have you tried using a Totals query? Just curious...
 

foshizzle

Registered User.
Local time
Today, 07:16
Joined
Nov 27, 2013
Messages
277
Have you tried using a Totals query? Just curious...

I must be doing something wrong.
2020-10-01_16-57-04.jpg
 

Users who are viewing this thread

Top Bottom