Search results

I have a main report with multiple sub reports. The main report references bound textbox controls on the various subreports with the Running Sum option set to Overall. (There is nothing in common between the various subreports). Problem The controls on the main report display the first/top...

I had to go another route and use each subreport's query for filtering the date. I did however find the information in here useful. Thanks for the tips guys!

I'm noticing the controls in the subreport for =[Forms]!frmReportBuildSum!txtStartDate and =[Forms]!frmReportBuildSum!txtEndDate are correct but it is not filtering the data in the subreport

*EDIT* attaching DB here I think I found the problem of why it wasnt updating all subreports: Since I am using Allen Browne's Method 2, I had to add the subreports to the code. So now, I have: controls on each subreport with =[Forms]!frmReportBuildSum!txtStartDate and...

Correct, the main report is unbound; as i am referencing the subreports on the main report for additional calculations.

I've been using Allen Browne's Method 2: Form for entering the dates on my reports. This works fine. I have a new report with multiple subreports. Is it somehow possible to link them all to the same date entered on the one (single) form? This is the form code to accept the date and open the...

Thanks so much to both of you!! I was actually able to get both these options working!

Hi CJ. Its actually not too late for me to change the the PK for the transactions table to be date and time; there is no real data yet and have not yet done any other queries based on this table. To clarify: There is a difference between "issued" and "received" fuel and these should be counted...

I see. The final goal is to have a report which displays the following for each airline, as shown on the attached screenshot: [previous_received], [new_received], (Subtotal = [previous_received] + [new_received]), [previous_issued], [new_issued], (Total = Subtotal + [new_issued]) On the...

I get a circular reference when adding to mine but give me some time to compare. thanks!

Hm, with this one, I get the same error message "At most one record can be returned by this subquery"

Ok, I adjusted the code as follows but now receive the error "At most one record can be returned by this subquery" *edit* SELECT tblTransactions.TransactionDate, tblTransactions.AirlineCompanyLookup, tblTransactions.IssueTypeLookup, tblTransactions.GallonsReceived, (SELECT TOP 1...

I have a similar code working for a different query but i cant get this one to match up. I'm trying to obtain the previous value for fields "GallonsReceived" and "GallonsIssued" but the code is literally giving me the value of the "...PriorValue" fields instead of the original, non-calculated...

Lol ok where's that easy button?? Thanks!

I must be doing something wrong.

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? SELECT tblTransactions.TransactionID, tblTransactions.TransactionDate, tblTransactions.AirlineCompanyLookup, tblTransactions.GallonsIssued...

Thats it! I had to make an adjustment to get the TruckNumber to show up properly but this is the final code with both Meters for each truck Thanks so much for your help! SELECT tblMeterReadings.MeterID, tblMeterReadings.TruckNumberLookup, tblMeterReadings.MeterDate...

I'm aware of that now but I've already got the entire DB built around the way its setup now. I changed the one table so they both read as SHORT TEXT data type. Not sure if that resolves that problem. I think I'm getting closer. Here is the updated code, but it just shows blank now instead of...

Attached. Thank you.

Thanks for your reply. It sort of makes sense. To make it a bit more confusion, I have an inner join which references another table. This is my code so far. It gives me a 'Type mismatch in expression' error. Can you help? SELECT tblMeterReadings.MeterID, tblMeterReadings.MeterDate...