Access 2000 Query/Report help, please

[Guest]

My database measures a task performed by all staff in the office. All are
date fields - i.e started task on January 1st and ended on January 5th. The
task has only 2 possible endings. Let's call it a) 1 field for turn left or
b) another field for turn right.

I can do one query to return accurate statistics on how many turned left and
another to return accurate statistics on how many turned right.

But how do I do a query/report to encompass both? If I do a query including
both the "turn left" field and "turn right" field, the return is nil. They
appear to be mutually exclusive. I.e. the query seems to be predicated on a
And/And basis. So how do I get it to do it on an "Or" basis. If it has to be
in a report, how is this done?

Regards,

A desperate newbie! :-((

 

[BruceM]

You could use report grouping to separate the two. Within each group you
could have a count. Set the Control Source of an unbound text box (I will
call it txtCounter) to =1. Set its Running Sum property to Over Group. You
could hide the text box and put into the group footer another unbound text
box with its Control Source set to =txtCounter.
Regarding the query, you will need to provide more information about how you
are specifying the parameters.