GRose
Registered User.
- Local time
- Today, 13:02
- Joined
- Mar 4, 2004
- Messages
- 21
Hello again,
Anyone know why this condition in a macro doesn't work:
DCount("[TESTqryPaymentRun]","STATUS") = 0
TESTqryPaymentRun is my query and STATUS is the field I want to count.
What is supposed to happen is if the count of records is 0 then a form is displayed. At the moment, the query has no records at all in it but when I run the macro, nothing happens, no form is displayed. I have used the condition before in another database to count the records in a table with no problems but I just can't get it to work. Could it be my references?
Ta
Anyone know why this condition in a macro doesn't work:
DCount("[TESTqryPaymentRun]","STATUS") = 0
TESTqryPaymentRun is my query and STATUS is the field I want to count.
What is supposed to happen is if the count of records is 0 then a form is displayed. At the moment, the query has no records at all in it but when I run the macro, nothing happens, no form is displayed. I have used the condition before in another database to count the records in a table with no problems but I just can't get it to work. Could it be my references?
Ta
