Querying on Now()

[mon]

I want to create a query which shows the records entered
over the last day. I have a field with default Now().
However I cannot manage the correct syntax for this.
Thanks
Mon

 

[Gary Miller]

"WHERE [YourDateField] > Date() -1"

Gary Miller
Sisters, OR

 

[Steve Schapel]

Mon,

Use either the Int() function or the DateValue() function, for
example...
DateEntered: Int([YourNowField])
.... and then put in the criteria Date()

- Steve Schapel, Microsoft Access MVP

 

[mon]

Thanks, but I am a dill. I have an upload field on each
table. If the records have just been entered then they
haven't been sent, so that field can be utilised. Thanks
for your suggestions, Steve and Gary. They have been
copied to my help file for future reference.
Thanks mon

-----Original Message-----
"WHERE [YourDateField] > Date() -1"

Gary Miller
Sisters, OR

I want to create a query which shows the records entered
over the last day. I have a field with default Now().
However I cannot manage the correct syntax for this.
Thanks
Mon

.