Dcount Question

[mateogp]

Im trying to count the number of records in a table in a certain field that match a certain criteria.

I've tried to figure out how to use Dcount with some success, but only in counting total records.

Here are two examples. The first one didnt work.

=DCount("RegisteredAt","tblGlobalReg","RegisteredAt=003 - Orland Park")
RegisteredAt is a FIeld name in the table tblGlobalReg.
RegisteredAt=003 - Orland Park is my criteria.

The second one, with out criteria did work.
=DCount("[RegisteredAt]","tblGlobalReg")

I guess my question is, how do I insert criteria?

Matt

 

[Mile-O]

"[RegisteredAt] = '003 - Orland Park'"

Although:

"[RegisteredAt] = ""003 - Orland Park"""

is safer.