Question Locked

MS ACCESS Macro Condition on current date month = 01

0 helpful

4 replies

by steveg Jul 2, 2009 last reply Jul 13, 2009

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

How do you set a condition on macro, which has a step for a report that you only want to run when the month is 01?

I've played around with Month(Date()) = '01' and similar with no success?

4 replies

Clarifications

01 is text but 1 is a number. I have just tried it with Month(Date())=7 and it works for me

Since current month is 7, try 1 and see if it runs still for you (it shouldn't). It did for me. Access97 SP3

I tried 1 and it didn't run for me. I have Access 2003 SP3 - sorry it didn't work for you. I'll give it another look

This discussion is closed to new replies.