Calculated Value

  • Thread starter Thread starter Everett
  • Start date Start date
E

Everett

I have a form & subform. The subform footer has an text
box with an aggregate function called TotSchFine with a
control property =Sum([ScheduleFine]) I can transfer
TotSchFine to the main form using =
[sfrmViolationsList].Form![TotCitFine].

I have a report and each line in the detail section
contains data from one form. My problem is that I can not
find a way to get the TotSchFine number from the subform
to the report.
 
The syntax is similar. Assuming a subreport name srptViolationsList and same
control name.
=[srptViolationsList].Report![TotCitFine]
 
Duane
Your answere implies that I have to have a subreport on my
report to get the summary number I want {TotSchFine}. I
really don't want to put on a subreport and all its detais
since several reports are summary reports with only the
top level information.
Using a Northwind analogy, I want a 3 column report
Vendor Invoice number Total billing
I guess I will study on the Northwind OrdersSubtotal
select query some more since it has the type of
information I need.

Thanks
-----Original Message-----
The syntax is similar. Assuming a subreport name srptViolationsList and same
control name.
=[srptViolationsList].Report![TotCitFine]


--
Duane Hookom
MS Access MVP


I have a form & subform. The subform footer has an text
box with an aggregate function called TotSchFine with a
control property =Sum([ScheduleFine]) I can transfer
TotSchFine to the main form using =
[sfrmViolationsList].Form![TotCitFine].

I have a report and each line in the detail section
contains data from one form. My problem is that I can not
find a way to get the TotSchFine number from the subform
to the report.
Click to expand...


.
Click to expand...
 
If you only want summary information on your report then create a
summary/totals/group by query to use as the record source for you report.

--
Duane Hookom
MS Access MVP


Duane
Your answere implies that I have to have a subreport on my
report to get the summary number I want {TotSchFine}. I
really don't want to put on a subreport and all its detais
since several reports are summary reports with only the
top level information.
Using a Northwind analogy, I want a 3 column report
Vendor Invoice number Total billing
I guess I will study on the Northwind OrdersSubtotal
select query some more since it has the type of
information I need.

Thanks
-----Original Message-----
The syntax is similar. Assuming a subreport name srptViolationsList and same
control name.
=[srptViolationsList].Report![TotCitFine]


--
Duane Hookom
MS Access MVP


I have a form & subform. The subform footer has an text
box with an aggregate function called TotSchFine with a
control property =Sum([ScheduleFine]) I can transfer
TotSchFine to the main form using =
[sfrmViolationsList].Form![TotCitFine].

I have a report and each line in the detail section
contains data from one form. My problem is that I can not
find a way to get the TotSchFine number from the subform
to the report.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top