Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
COUNTING 1
- Thread starter chubby
- Start date
-
1
- #2
chubby,
I think your post has to go down as one of the vaguest questions this year.
What do you want to do exactly? Count the number of records that have 'Yes' values for a field in a table? If so, then =DCount("[Field1]","Table1","[Field1]") should work.
Did you want to count the number of Yes/No check box controls on a form? If so, then you'll need to write some vba code.
Cheers.
I think your post has to go down as one of the vaguest questions this year.
What do you want to do exactly? Count the number of records that have 'Yes' values for a field in a table? If so, then =DCount("[Field1]","Table1","[Field1]") should work.
Did you want to count the number of Yes/No check box controls on a form? If so, then you'll need to write some vba code.
Cheers.
- Status
Similar threads
- Locked
- Question
- Locked
- Question