Counting yes/no selection in a query.

G

Guest

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?
 
G

Guest

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

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
Yes / No query problem 4
counting yes/no fields 3
Counting YES/NO in a Table with a Query 5
Counting a yes/no field 2
dynamic calculated field in query 3
Counting up Yes/No fields in queries 3
Countif on qry 6

Top