Between [First Date] And [Last date]

John, Rick,Duane,kc-mass...I am much obliged. Thank you indeed...Looking at
all these suggestions..and testing..it is simple....thats why it is
difficult.. It works when adding a day in seconds or not using the Between
but operators..

Once again, Thank you for the lesson...i learned something new today..

"John Spencer" wrote:

Dang!! Wrong constant there are 86400 seconds in a day not 24000.

BETWEEN [First Date] and DateAdd("s",86399,[Last Date])

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

John Spencer wrote:
Try using the following criteria

BETWEEN [First Date] and DateAdd("s",23599,[Last Date])

The DateAdd function adds 23599 seconds to the value of Last Date so
that the datetime value is one second before midnight on the date you
enter for Last Date. So you will get all records between midnight of
first date and one second before midnight on the last date.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Peter wrote:
Hiand thanks, but i am a lite confused. I use the Between [First Date]
and [Last Date) in a parameter/criteria that results in two small
popup windows where the user populate the frst date and second in
order to retrive allrecords between these two dates...but i dont
understand how that would function in your solution..all i want to do
is to retrieve records between two dates...The datecreated field is
populated by code and it seems that i can not just reformat the field
to ex dd-mm-yy.
.