Macros don't "go through" tables. Queries process all Records in their data
source. Why would you want to try to jump through hoops to make a Macro do
something that a Query is designed and intended to do?
You haven't stated the condition you wanted to test in each Record, so I
can't be more specific. In the Query Builder, add the Table of interest to
you, drag down the Fields of interest, and in the Criteria line, specify the
Criteria. That, done correctly, will retrieve just the Records that satisfy
the Criteria you specify.
You can use that Query as the RecordSource of a Form or Report, both of
which you mention in your question. Or, as you mention here, you can go to
View | Totals, specify Count for the Record identifier, and that will give
you the value to answer the question you asked here -- are there any clients
for which the condition is true.
Larry Linson
Microsoft Office Access MVP
