I am using Access 2007. In my report I am using a table(ACXIOM) for the record source. I want to count the number of "REJECT" records in the field called SORT_DECISION_CODE. I have a text box field and for the control source I am using:
=Count(([ACXIOM].[SORT_DECISION_CODE])="REJECT")
This is giving me the total record count of all records in the table and not just the REJECT records.
Any ideas or what my approach should be?
Thanks to any who answer!!
Bruce D.