Can't seem to figure this one out.
Now when the form loads up it is always going to the esle statement wven when I set the time to the if statement.
Anyone see anything why it wouldn't work.
Thanx
Code:
If (FormatDateTime(Now(), vbLongTime) > #9:00:00 AM#) And (FormatDateTime(Now(), vbLongTime) > #9:00:00 AM#) Then
SQL = "expression"
else
SQL = "diffexpression"
end ifNow when the form loads up it is always going to the esle statement wven when I set the time to the if statement.
Anyone see anything why it wouldn't work.
Thanx
