DCOUNT?

chastst

Registered User.
Local time
Today, 23:15
Joined
Oct 19, 2000
Messages
17
I have a question about counting records in a report. I have a report based on a query called "REMBTF". The field I want to count is "ID" and I only want to count the ID if it = "RW". Can someone please help me with the syntax of this issue?
 
DCount("ID", "REMBTF", "[ID] = 'RW'"). You can use this in the query or an unbound field in the report. In the query substitue the table name for the query name....

[This message has been edited by Jack Cowley (edited 10-19-2000).]
 
This posts a response of #Error in my report. Any other suggestions?
 

Users who are viewing this thread

Back
Top Bottom