Results 1 to 6 of 6
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report Total in Page Footer (03)

    The expected value being returned in a text box located in the page footer is returning #Error. The control source is quite simple: =Sum([Amt1]). The detail section is also referring to the field "Amt" and is displaying the correct records. It is just the sum of the records for field "Amt1" that is giving me a challenge.

    Any ideas as to why?

    Thanks,
    John

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report Total in Page Footer (03)

    You should put the text box in the report footer instead of in the page footer.

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Total in Page Footer (03)

    Hans,

    Thanks for the suggestion as it worked. One more question if you don't mind...Is it possible within the same report to to include in the report footer another text box whose source control references a different query? My attempts using the expression builder returns #Error.

    Thanks,
    John

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Report Total in Page Footer (03)

    You will need to give more info than that if you want help to solve your problem.

    #error indicates an undefined variable.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report Total in Page Footer (03)

    You can use one of the domain aggregate functions such as DSum, DCount etc. For example, to return the sum of the values of the field MyField from the query MyQuery, use

    =DSum("MyField", "MyQuery")

    To get more info, activate the Visual Basic Editor (Alt+F11), activate the Immediate window (Ctrl+G), type DSum and press F1.

  6. #6
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Total in Page Footer (03)

    Hans,

    Thank you. It is quite interesting how similar access functions are to Excel.

    Regards,
    John

Posting Permissions

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