DCOUNT? (1 Viewer)

[chastst]

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?

 

[Jack Cowley]

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).]

 

[chastst]

This posts a response of #Error in my report. Any other suggestions?