- Local time
- Today, 04:30
- Joined
- Oct 29, 2018
- Messages
- 22,487
Okay, I fixed Query2, it now shows like this.Sorry, I compared my Excel results to your query and i found the problem; i had entered an extra beginning balance on my sheet. So your numbers are absolutely correct!! I just need two minor adjustments:
- I need to show the subtotal column as another column in the query (for report purposes), as shown in the attached 'report_ex.jpg'.
- For the query results with no GallonsIssued or GallonsReceived, the Total number still needs to show (which would equal the BegBalance), as shown on the updatedQueryExample.jpg
So, if I am beginning to understand your requirements, I don't think you need to use the TOP queries (I'm not using them here). We could make this query (Query2) to prompt the user for the Report Date, and it will only show the data for that date.