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.