form filter

[sdavid74]

Is there any way to put a filter on a DCount function so that it will only count records that meet certain criteria?

My goal is to count the number of records marked "true" that are contained in "MyTable" and record that number on "MyForm"

Any ideas?

 

[gol4]

Certainly
Dcount("fieldname","[tablename]", "fieldname = true&quot

dcount() uses the arguments

DCount(expr, domain[, criteria])

 

[sdavid74]

Thanks, I appreciate you taking the time to help with such an simple problem. That did the trick.