Date/Time Return all in Specified Date

  • Thread starter Thread starter Snickers
  • Start date Start date
S

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.
 
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.
Click to expand...

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?
 
Thanks, It's a company database, not mine exclusively.

fredg said:
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.
Click to expand...

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?
Click to expand...
 
Back
Top