Feeling really stupid

[Gina Maylone]

Done it a thousand times, and cannot get it now. I simply need the total from my subreport (Mileage) to show up on my main report (bidreport). I have the following field in the BidReport report footer:

=[Mileage].[Report]![MileageGrandTotal]

and it will only give me the last group total from the subreport! I've tried all sorts of variations. does it matter that I have the Mileage subreport in the BidDate footer of the BidsReport? I am trying to show mileage for each day - and then a grand total at the end.

TIA. Happy Memorial Weekend all!

[ranman256]

ALWAYS use the builder button. This will allow you to pick the item from a list and spell it correctly.
you would have chosen , REPORTS, OPENREPORTS, rMyreport, childRpt, [milageTotal

So whatever the text box name is....NOT the name of the field, but sometimes they ARE the same.
but you must reference the SUB RPT name. usu CHILD1,2
[child1].[Report]![MileageGrandTotal]

[Gina Maylone]

I did! The name of the subreport is "Mileage". And the name of the field is MileageGrandTotal.

[June7]

I always give container controls a name different from the object they hold, like: ctrMileage.

Then reference field:

=[ctrMileage]![MileageGrandTotal]

reference a control:

=[ctrMileage].[Report].[tbxMileageTotal]

[Gina Maylone]

I always give container controls a name different from the object they hold, like: ctrMileage.

Then reference field:

=[ctrMileage]![MileageGrandTotal]

reference a control:

=[ctrMileage].[Report].[tbxMileageTotal]

Thank you June, I had in fact tried changing the name after I posted my question to no avail. This really makes no sense what-so-ever. I've tried recreating the reports in case something was wonky - and nothing.

[June7]

If you want to provide db for analysis, follow instructions at bottom of my post.

[Gina Maylone]

newdbzip.zip
Ok here it is. thank you so much for taking the time.

[June7]

Doesn't seem to be pulling the last group total from the subreport, it is pulling 98 which is the second although it is the last record in the unindexed Mileage table. Interesting, would not have expected that.

As structured, each contact can have only one bid date. Which is fine if repeat customers is not common in your business operation. The Mileage table has only bid date as identifier. Yet there are multiple contacts for a date. Shouldn't the Mileage table have contact ID as foreign key? Are all miles for a date lumped together? If so, there is no way to break out miles to each contact. If that doesn't matter then I suppose the date as key field is fine.

Seeing the report and then re-reading your post does help. Changing location of subreport does not help. Removing the Master/Child links does allow the expression to pull a grand total but then the subreport displays all mileage dates under each bid record. Cannot get the grand total you want by referencing that subreport. This will require another subreport in the report footer or a DSum() expression or a nested subquery in the main report RecordSource.

[Gina Maylone]

Doesn't seem to be pulling the last group total from the subreport, it is pulling 98 which is the second although it is the last record in the unindexed Mileage table. Interesting, would not have expected that.

As structured, each contact can have only one bid date. Which is fine if repeat customers is not common in your business operation. The Mileage table has only bid date as identifier. Yet there are multiple contacts for a date. Shouldn't the Mileage table have contact ID as foreign key? Are all miles for a date lumped together? If so, there is no way to break out miles to each contact. If that doesn't matter then I suppose the date as key field is fine.

Seeing the report and then re-reading your post does help. Changing location of subreport does not help. Removing the Master/Child links does allow the expression to pull a grand total but then the subreport displays all mileage dates under each bid record. Cannot get the grand total you want by referencing that subreport. This will require another subreport in the report footer or a DSum() expression or a nested subquery in the main report RecordSource.

This little db is something I had to slap together for myself in the couple of minutes I had to get a report out. Thus the need for the Grand total of mileage, which I only need by date, not by bid.

Thank you for taking a look at it June, at least I know the issue isn't my imagination.