Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    Arkansas, USA
    Posts
    163
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report Help (Access 2K)

    I need a little help on a project I need to finish this weekend. I have a report that lists records with various types of information. I have the report grouping the records by month and by employee. I want all of the records for the month to show on the report. Some of the fields should total for the month and the employee. This is already set using the SUM function, no problem. However, I want some of the fields to total only if certain criteria is met. For example the field FIELD1 should be included in the monthly and employee total only if FIELD2 (a check box field = TRUE). The DSUM function allows me to set the criteria, but does not let me utilize the grouping feature on the report. If this does not make sense I will be happy to try to clarify.

    Thanks in advance for any assistance.

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Report Help (Access 2K)

    Here is one idea. In the underlying query include a calculated field.
    Field1a : iif([field2]= true, [field1],0)
    Field1a is field1 if field2 is true, otherwise it is zero.
    Include field1a in your report, but hide it. Sum field1a, but show that as the sum of field1.
    Regards
    John



  3. #3
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    Arkansas, USA
    Posts
    163
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Help (Access 2K)

    Thanks for the help. It works fine.

Posting Permissions

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