In Access, how do i pull up todays date information in a form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to pull the data from a table and put it into a form/subreport. I
want to be able when i pull it up it just show that employees information for
that date. It now shows all the dates that are in the table. This is a
Employee Time Sheet Program.

Thanks

William
 
I am trying to pull the data from a table and put it into a form/subreport. I
want to be able when i pull it up it just show that employees information for
that date. It now shows all the dates that are in the table. This is a
Employee Time Sheet Program.
Click to expand...

Create a Query based on this table; on the Criteria line under the
date/time field put
= Date() AND < Date() + 1
Click to expand...

to get all times for today's date.


John W. Vinson[MVP]
 
PMFJI but as a Access novice, why cannot you just look at Date()?.

Create a Query based on this table; on the Criteria line under the
date/time field put


to get all times for today's date.


John W. Vinson[MVP]
Click to expand...

Please remove obvious from email address if emailing.
 
John's covering the possibility that the date field includes time as well:
that the field was populated using the Now() function.
 
Ok, I understand now. Thank you.

John's covering the possibility that the date field includes time as well:
that the field was populated using the Now() function.
Click to expand...

Please remove obvious from email address if emailing.
 
Back
Top