Hi all,
I wonder if you could help me out with this one.
I am trying to create an "IF"/"Else" statement in a macro design of my database.
What I am looking for is to apply the IF statement to the current time. Is there a function called "systime" or similiar? I want the IF to look at the current time, and if it is before 2pm, run the query below, ELSE, only come come up with a message box.
BEFORE I used the below which was looking at the "YES" or "NO" appearing in my table, however I need it to be looking at the current time, cause I do not want some data to be processed if it is after 2pm...
Hope you know what I am talking about?
Any help/hints would be much appreciated.