OK...here we go!
I have a query that counts the number of occurences of something in a table.
Then I have a macro that I want to run if that query counts more than 0 occurences of this thing. I tried to set this up as a condition in the macro but with no success. What I have in the condition statement is:
[QryCountNoCode]![CountOfNoClientID]>0
Where "QryCountNoCode" is the name of the Query
And "CountOfNoClientID" is the field name where the result of the query is displayed
Do I have this set up wrong? Please help!!
Thanks!
I have a query that counts the number of occurences of something in a table.
Then I have a macro that I want to run if that query counts more than 0 occurences of this thing. I tried to set this up as a condition in the macro but with no success. What I have in the condition statement is:
[QryCountNoCode]![CountOfNoClientID]>0
Where "QryCountNoCode" is the name of the Query
And "CountOfNoClientID" is the field name where the result of the query is displayed
Do I have this set up wrong? Please help!!
Thanks!