NEED REPORT TOTALS – NBS

Topic

New Reply

NEED REPORT TOTALS – NBS

I have a report that prints a detail listing that includes the following two columns:

Name: PermitFees
Control Sourse: =[BuildFee]+[FilingFee]

Note: BuildFee & FilingFee are two non-visible controls in the detail line.

Name: SewerFee
Control Source: =DSum(“[curFees]”,”tblBPFees”,”[tblBPFees].[lngBPermitID] =
[qryPermitRoadReport]![lngBPermitID] and [tblBPFees].[lngFeeTypeID] =GetPref(‘Sewer Fee ID’)”)

The detail lines for PermitFees & SewerFee print OK

In the report footer I have two text boxes and want to print a total for the above two columns.

I’ve tried many attempts with the expression builder and can’t get totals to print.

What am I doing wrong?

What should the control source be for Total PermitFees & SewerFee

Thanks, John Graves

Reply | Quote

Replies

I find it easier to try to put as much in to a report’s underlying query as I can, rather than rely on DSum (and other aggregate functions) in the report. A subquery in the original query can provide this information. Then, you can simply have a textbox in your report footer whose controlsource is “=Sum(SewerFee)”.

As for PermitFee, assuming that BuildFee and FilingFee are fields in the query, you can total this in report footer with a textbox that has a controlsource of “=Sum(BuildFee+SewerFee)”

Reply | Quote