Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    NEED REPORT TOTALS - NBS

    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

  2. #2
    sabrantley0623
    Guest

    Re: NEED REPORT TOTALS - NBS

    I would usually copy those two fields into the footer, and have it as Sum([field1]+[field2]). Otherwise, I sometimes have a query run whenever the quantities are updated in the data entry screen, and records the sum in a totals field.

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: NEED REPORT TOTALS - NBS

    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)"
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •