AutoExec Macro Help

[kini113]

I have 2 AutoExec macro's that run at a specified time every morning (1am) but 1 of those macros can't be run more then 1 time a day. I found a set up on a previous post that almost solves my problem, but the StopMacro condition gives me a syntax error.
Here's what i have so far...
A table named "tblLastUpdate" with a field "DateUpdated"
A query in the macro which will append that table with the date it runs on. (should this be an append or an update query?)

The Macro condition i found is
DCount("*",tblLastUpdate","[DateUpdated]#="&Date()&"#")=0

but it gives me a missing operator syntax error any help would be wonderful

[TheSmileyCoder]

Try
DCount("*",tblLastUpdate","[DateUpdated]=#"&Date()&"#")=0

I think you should be able to do simply:
DCount("*",tblLastUpdate","[DateUpdated]=Date()")=0
The last solution is neater and faster, and should work, though I havent done much work in macros.

[kini113]

I don't get an error message with those condition syntax but it doesn't stop the macro from running even when the condition is met. Baffled....

[TheSmileyCoder]

And you have tested that the expression
DCount("*",tblLastUpdate","[DateUpdated]=Date()")=0
evaluates as you expect it to?

Ie. that it is false when you have data for that date in the table.

[kini113]

Changed it to make it a true statement and it works :) Thanks so much for your help