Querying on Now()

  • Thread starter Thread starter mon
  • Start date Start date
M

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
 
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
 
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
Click to expand...


.
Click to expand...
 
Back
Top