Results 1 to 2 of 2
Thread: Count (97)
2002-03-14, 13:51 #1
- Join Date
- Feb 2001
- Louisville, Kentucky, USA
- Thanked 0 Times in 0 Posts
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.
ThanksRoberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
2002-03-14, 14:20 #2
- Join Date
- Dec 2000
- Burwash, East Sussex, United Kingdom
- Thanked 187 Times in 173 Posts
Re: Count (97)
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,
Microsoft MVP - Excel