Search results

Thank you; this makes sense and worked perfectly. I believe there is a reason for keeping the fuel received and issued separately but will follow up w that dept to verify. Thanks for everything!

Wait up. Think i may have figured it out; its adding all airlines but even if i specify the airline in the criteria its the same. i need to now get the results by each airline name

Thank you for that information. I've now tried including the date criteria inside the DSum. I'm getting a different number but still, an unexpected result. The correct DSum result for gallons received should be 135154. I am getting 480213 which doesn't match anything. Here is my updated DSum...

Good catch. the day before the query criteria on 11/30/20, there was a negative entry of the same amount I'm off. This is because the value was used as a starting balance; we are using this database to transition from an old one which had alot of hard-coded values. Still, shouldn't the DSum...

For troubleshooting purposes, I have made two queries looking at the same table. One query 'RunGalIss' accurately uses DSum to total gallons issued for a particular group within a specified timeframe. However 'RunGalRcv' is setup the exact same way but starts with a negative value instead of 0...

Hey DBGuy, I finally had a chance to get some data from the user today and the reports match after entering in the beginning balance! Thanks for your help and perseverance!

Hi DBGuy, checking in for the remaining code when available. Thanks so much for all your efforts and patience here

Lol - I've been checking all day and I didnt realize there was a second page for this post.. For your comment"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...

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)...

Hm, the Totals are a little off. Can we try something else right quick? Sorry for the difficulty and misunderstandings. This one thing has been beating me up for a week now. After all the research and seeing your examples, I think I've come up with an alternative using a combination of your MAX...

Ok, great!, I found this link, and was trying to make it work with your MAX query. How then, would I show the MAX date from this? SELECT qryReportSumAirlineTransactionsAll.TransactionDate, qryReportSumAirlineTransactionsAll.AirlineCompanyLookup, qryReportSumAirlineTransactionsAll.SumIssued...

Can I ask how you got the results from your Query1 screenshot?

Thanks for your help thus far; i didnt realize it would be this difficult. i've attached a spreadsheet which I had to compress in order to post here. Really hope that helps. please let me know if you need further clarification.

By "current", I mean the most recent record's date. Regarding the Top1 query, I believe your logic is correct. Only three airlines had flights on the most recent date. But, in reference to your PSS., the report will need to show ALL airlines regardless of whether or not they've had a...

Its kind of confusing to setup because this is a newly built DB, based off an old one in which every field was hard-coded, including the calculations. The new report needs to mimic the original report in the previous DB. Explanation of Data tblAirlineTransactions is a table of fuel gallons...

attached - thank you

I have two queries which are used to get the SUM of previous record groups and the group prior to that using TOP 3 and TOP 2. (I need the 3 most current groups of records). Now I need to reference those SUMs (for each group/airline) for additional calculations; I'm guessing through another...

I AM able to get running totals in the report, but the report requiring the running totals is a sub-report. So, when I reference the Running Sum control on the sub-report from the main report like =[rptSum2AirlineTransactions].[Report].[txtRunSumIssued]), the value is only updated when the...

I was wondering if anyone could point me in the right direction: I've added two new queries (based off one original query) in order to get different totals. The last step is to get a running total from certain fields. Surely I'm doing this the hard way but the general hierarchy is...

You're not going to believe this but I went to lunch and when i came back, its working now.. not sure what I did right before i left. I went to make a sample of the DB to upload but it is also working.. I dunno but hope its some freak/intermittent thing.. Open the frmReportBuildSum and enter...