DCount on Yes/No Fields

[Tiredmom]

I need to count how many yes and no answers I get in a certain field in my database. Would DCount be the function I would use?

 

[TTThio]

Here it is:

x = DCount("[Field1]", "Table1", "[Field1] = Yes&quot
y = DCount("[Field1]", "Table1", "[Field1] = No&quot

Good luck,
Tin Tin

 

[duke11]

TTThio - I'm having the same problem and don't quite understand where to put the formulas in. I have done basic access applications and only know a little on formulas. Can you help? s-)

 

[walkerhunter]

you can use the Dcount functions in columns in your queries. You can add them to reports and forms also. They are very useful, but add some overhead. MS Access help has a pretty good explanation of how to use them.