What does this mean in criteria for date? Thanks
On Mon, 25 Aug 2008 13:44:07 -0700, Novice2000 wrote: > What does this mean in criteria for date? Thanks It means the query should return those records whose date field has a date value greater than or equal to yesterday at whatever time of day you are running the query. In other words, if you run the query today (8/25/2008) at 1:50 PM, it will return all record between 8/24/2008 1:50 PM on into the future. Records with a time value of 1:49 PM and earlier will not be returned. Most often, the time value is not a part of a date entry, so it's best to use Date() instead of Now(). >= Date()-1 will return all return all records from yesterday on into the future, regardless of the time the query is run. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
