date Criteria

  • Thread starter Thread starter warroowarrior
  • Start date Start date
W

warroowarrior

Hello all, I need to run a query each morning that will give me data entered
yesterday. What do I put in the criteria section that will only show me
yesterdays data entries. Much appriciated if you can help
 
Try Between Date()-1 AND Date() assuming you have time with the dates.
If there are no time then just Date()-1 will do it.
 
Thank you for your advice Karl, I am in the early stages of learning access.
what I am trying to achieve is to run the query each morning and copy it
into a XL spread sheet. but I don't want to have to set the date each day in
the design view window. What I would like, is for the query to run, but only
display the data entered yesterday. Is that possible. If it is can you tell
me exactly what I should type in the criteria section. I have tried =
today(), and now(), just as an experiment to get it to run, but that does not
work either.
Hope you can help
 
Thank you Karl your answer solved my problem, I had typed it in wrongly the
first time. You have a great day
 
Back
Top