Date/Time field

[gillianleec]

I want to run a query that captures records that have a date and any time during that day. I am currently using
>=Date(). I would like to use a between statement but not sure what to write. Any ideas?

 

[PaulBricker]

Between [Enter Start Date] And [Enter End Date] +1

That should do it.

Paul

 

[PaulBricker]

That worked for a number field. For a date field I had to use
Between [Enter Start Date] And DateAdd("d",1,[Enter End Date])

Paul

 

[CosmoKramer]

Between [Enter Report Date] & " 00:00" And [Enter Report Date] & " 23:59"

Hoc nomen meum verum non est.

 

[dhookom]

I prefer to create calculated column in the query
DateOnly: DateValue([DateField])
then set the criteria to a date only value.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[gillianleec]

Thanks for all the suggestions. They all worked for what I need!!