Date/Time Return all in Specified Date

[Snickers]

I have a table containing date/tame info as mm/dd/yyyy hh:nn:ss AMPM, I want
to put together a parameter query that prompts you for a date and returns all
records regardless of time as long as the date matches.

 

[fredg]

I have a table containing date/tame info as mm/dd/yyyy hh:nn:ss AMPM, I want
to put together a parameter query that prompts you for a date and returns all
records regardless of time as long as the date matches.

So you do not need the time value in either the starting or ending
days?

Create a new query that returns all of the records.
Then as criteria on the Date/Time field, write:

Between [Enter Start Date] and DateAdd("d",1,[Enter End Date])

When prompted enter the [Start Date] as
10/2/2008
When prompted again, enter the End date as 10/7/2008

All records between the entered dates, regardless of time, will be
returned.

If you don't need the time value why are you storing it?

 

[Snickers]

Thanks, It's a company database, not mine exclusively.

I have a table containing date/tame info as mm/dd/yyyy hh:nn:ss AMPM, I want
to put together a parameter query that prompts you for a date and returns all
records regardless of time as long as the date matches.

So you do not need the time value in either the starting or ending
days?

Create a new query that returns all of the records.
Then as criteria on the Date/Time field, write:

Between [Enter Start Date] and DateAdd("d",1,[Enter End Date])

When prompted enter the [Start Date] as
10/2/2008
When prompted again, enter the End date as 10/7/2008

All records between the entered dates, regardless of time, will be
returned.

If you don't need the time value why are you storing it?