Search results

Hi - I didnt provide the report in the original sample because its the same data in the query. However, I've attached the report to this new sample DB for your reference here. I see your confusion because Its the same problem I had when trying to figure this out.. In summary, this is a...

Here is a sample: The top query was run for 4/30/21. The bottom query was run for 5/1/21. (We don't yet have 5/31 data since its still May). If I were to run a query for 5/1 (or 5/31), the DailyBal should be the end of the previous month's (4/30/21) ActualBal. Note, this new value has nothing...

Thank you for your response. I just cant figure out how to get both previous values for two different dates in the same query. Attached is a sample, following the instructions in your post. I've been using dates 4/30/21 and 5/1/21 for testing. Thank you

First off, apologies as this is my 3rd attempt at getting this report right. Please allow me to start fresh here: I now have the following queries: qryRMonthlySum2_DailyBal - uses data from qryRMonthlySum3_Compare to obtain daily transaction balance (DailyBal) for each airline. The DailyBal is...

Two questions: If I include a WHERE, wouldn't that still keep the gain/loss value for that point in time? In reference to your proper joins statement; are you referring to the qryRGainLoss15Report? I figured this one out on my own and as you can probably tell, I'm not a DB guy; it took me 15...

I am using qryRMonthlyGainSum4GainLoss (below) to obtain the Actual Balance as follows: ActualBal: Nz(([Total]+[AirGainLossNZ]),0) Another value for gain/loss, called AirGainLossNZ, is calculated in a separate query as shown below in qryRGainLoss15Report. Somehow I need to reset the value for...

Sorry; to clarify, I need to be able to use the value for the previous ActualBal in a new query

I have the following query which will run on any given date. How could I obtain the previous value for ActualBal? i.e., if the report date is run for 5/1/21, would could I get the ActualBal for 4/30/21? SELECT qryRMonthlySumTrans2.TransactionID, qryRMonthlySumTrans2.TransactionDate...

ok; nevermind. I still cant figure it out. Here is a fresh copy.

Standby. I think i know the problem.

I have a report which shows a summary of current month's inventory and transactions.I need to roll the previous ACTUAL BALANCE into the next month's report which will become the new month's BEGIN BALANCE. These numbers do not appear to be updating.. Hoping someone can point me in the right...

WOOHOO! Thanks for all your help and suggestions! Since the report is working faster, I no longer need the progress bar (sounds like this was part of the issue anyway). I guess I was confused previously about your report suggestion. The main report now contains the summary and the detail is the...

Thanks for the insight! 1. I've indented my code as best as I could now (I'm not a programmer) 2. .text property has been removed; thanks for the explanation here 3. I did have a page break set but removed it for troubleshooting. I've added it back in the new db sample here. 4. PDF still isnt...

Ok, new results: I now have the one set of reports; no if statement required when choosing (All) or a single airline customer. If a single customer is selected, the report runs correctly but never exports to PDF (this was working before). If (All) is selected, I believe all the report data is...

Pat - I did try the page break option but unfortunately this does not solve my issue. I need to show the summary results for each customer along with each customer; not at the end in the report footer. I have an idea which may solve my problem: Since each subreport is based off a separate...

yes, i can get the report to open now; i'm just having trouble trying to figure out how to get the data for each airline including the summary, separated by page. i think im going to have to rebuild the report or query to get all the data i want to show... i.e., the detail subreport and summary...

Thanks everyone for your suggestions. I haven't updated this post yet because I started rebuilding the report in order to match both "All" and single item selections from the combo box per Pat's suggestion. Just having trouble making it work in order to display the summary along with the airilne...

that sounds right. please see attached. I'm using the dates 4/1/21 - 4/7/21 for testing.

ok; i still have a problem here bc Access crashes when bound to column 2.

ok, this is what the form looks like now. I've set it to show 2 columns so you can see the underlying value. When I select (All) from the combobox, the selection turns blank (null). Any thoughts on keeping keeping (All) after the selection has been made so the user understands their selection...