Why does my DCOUNT expression not work in Microsoft Access?

E

Enlightened One

New member
Expr1: DCount([Parking]![Ticket Number],"Parking",[Parking]![Rate Code]=2)

I am trying to count the number of tickets when my rate code=2. Both are in my Parking Table.

Table= Parking
Rate Code and Ticket Number are both columns. My rate code can either be 1 or 2.
 
Back
Top