Current day Total Query

[Wapug]

I have a table on which I post the volume of items, total less than 10 days aged and total greater or equal to 10 days for three separate ledgers each day. What I'm trying to do is write a query that looks at this table and returns the total of the three items for the three ledgers combined.
Ex,
Date ledger vol <10 >=10
7/3 Wire 800 798 2
7/3 Ach 435 427 8
7/1 LWip 376 260 116

I want to be able to query for current date (7/3) and get just the combined totals in the vol, <10 and >=10 columns in one row

 

[sneuberg]

Suggest this video to get you started.

 

[plog]

Can you demonstrate your issue with data? Provide 2 sets:

A. Starting sample data from your table(s). Include table and field names and enough data to cover all cases.

B. Expected results of A. Show what you hope to end up with when you feed in the data in A.