Hammer136 Posted February 28, 2006 Share Posted February 28, 2006 HiI 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 Link to comment Share on other sites More sharing options...
Anne Troy Posted March 3, 2006 Share Posted March 3, 2006 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now