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