MS Access Date Problem

[Hammer136]

Hi

I am doing an access project and i need a calculation to work out whether the date is the first day of a month to put in a condition for a macro. I wish to use no fields to store any information if possible.

Thanks

[Anne Troy]

I don't know how to write it in code, but here it is as a formula:

=IF(DAY(NOW())=2,TRUE,FALSE)

This might help you use it:

http://office.microsoft.com/en-au/assistan...1102181033.aspx