Results 1 to 2 of 2

Thread: Count (97)

  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Count (97)

    OK...I'm not sure if this can be done, but here goes.

    My table has a couple of fields, Verified and Updated, which are yes/no fields.

    When the user prints, verified becomes true, when the user updates the record, updated becomes true.

    In my report, I need to provide how many records were printed and how many records have been updated.

    How can I accomplish this. If I put "yes" in the query for verified, the count is correct, however, when I put "yes" in the query for updated, I get the correct value for all the records that have updated. I want the correct number printed AND the correct number updated.

    Thanks
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Count (97)

    Hi Roberta,
    In a totals query use the expressions Abs([Updated]) and Abs([Verified]) and sum both of them. Because True (or Yes) evaluates to -1 and False (No) to 0, this will give you the relevant counts for each. The Abs simply removes the negative signs.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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