Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2014
    Posts
    14

    Unanswered: Report group total = 0.00

    My report totals monthly costs for a group. As I have it now, that field is blank on the report if total is 0.00. I want it to print 0.00 if no costs in the table for that month.
    Last edited by DavidTayse; 06-07-14 at 08:31.

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Assuming that this Field being totaled is defined as Currency, as it looks, you can do something like this for the ControlSource of the totals Control on the Report:

    =(Nz(Sum([MontlyCosts]),0))

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Apr 2014
    Posts
    14
    Thanks - it has been a while... I had forgotton about the Nz function

  4. #4
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Glad we could help!

    Welcome to dBforums!

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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