Counting yes/no selection in a query.

E

elizaldej

I have a query that contains the following expression:

Expr1: Sum(DCount("[Aviation Assistance 1]","Main Table","[Aviation
Assistance 1] = True")).

This expression gives me the total count of my yes/no field "Aviation
Assistance 1" in my entire table. What I need is the total count of the
yes's in my yes/no field "Aviation Assistance 1" for just the time frame (ex.
August 5-August 17) of the query that I am running. Can someone assist?
 
C

CurtainMary

Use the Between #date1# and #date2# as the criteria under the Date field.
CurtainMary
 
E

elizaldej

Thank you, it worked perfect.

Duane Hookom said:
Try this
Expr1: Sum(Abs([Aviation Assistance 1] = True))

elizaldej said:
I have a query that contains the following expression:

Expr1: Sum(DCount("[Aviation Assistance 1]","Main Table","[Aviation
Assistance 1] = True")).

This expression gives me the total count of my yes/no field "Aviation
Assistance 1" in my entire table. What I need is the total count of the
yes's in my yes/no field "Aviation Assistance 1" for just the time frame
(ex.
August 5-August 17) of the query that I am running. Can someone assist?
Click to expand...
Click to expand...
 
Top