G Guest Apr 14, 2004 #1 How Would I go about setting up a parameter that would poll the last 24hrs, I was thinking one might be able to utilize the Now function but not sure.
How Would I go about setting up a parameter that would poll the last 24hrs, I was thinking one might be able to utilize the Now function but not sure.
D Duane Hookom Apr 15, 2004 #2 A criteria of Now()-1 will retrieve date values less than 24 hours old. -- Duane Hookom MS Access MVP Derek said: How Would I go about setting up a parameter that would poll the last Click to expand... 24hrs, I was thinking one might be able to utilize the Now function but not sure.
A criteria of Now()-1 will retrieve date values less than 24 hours old. -- Duane Hookom MS Access MVP Derek said: How Would I go about setting up a parameter that would poll the last Click to expand... 24hrs, I was thinking one might be able to utilize the Now function but not sure.
D Duane Hookom Apr 15, 2004 #4 For today: DateValue([YourDateField]) = Date() For Yesterday: DateValue([YourDateField]) = Date()-1
