Dates in a query

  • Thread starter Thread starter digitallifeform
  • Start date Start date
D

digitallifeform

Hi all. This is my first visit...

I am creating a query at the moment which is to be run everyday fo
reporting. I dont want to go in and change the date it reports o
everyday....

Is there a way i can get it to report on "today's date" when it runs?

What is the criteria expression i would need to put in.

Many thanks

digita
 
If you are using that query for a report or a form, the answer is easy
just add a field to the form and set the datasource to "=now()
(without the quotes) and format to a format of your choosing from th
dropdown list. Today's date, provided that it is correct in th
computer clock, will print/show up on the screen.

Roge
 
=Date() would be a better choice since Now() includes time of day and will
interfere with finding correct records.
 
Back
Top