Re: Count All Records Where Record Equals Value
post the sql or code that you tried, otherwise we aren't sure what your field/table names are.
Is [Record] the query name, or is that the table that the query is based on?
Or assuming OnTime is a number field and not text, try
MyField: DCount("[OnTime]", "[Records]","[OnTime] = 1")
Last edited by Micron; 01-29-2019 at 12:29 PM.