Using a parameter query with date and time

  • Thread starter Thread starter Alex Martinez
  • Start date Start date
A

Alex Martinez

Hello,

In my parameter query I have a field called "Rec'd Date" that shows date and
time for example - 2/28/2006 11:20:28 AM or 2/28/2006 my problem is when the
query pops up asking for the Rec'd date I would input 2/28/2006 I only get
the 2/28/2006 data not the 2/28/2006 11:20:28 AM or 2/28/2006 date with
another time. I know I can change the field to only have mm/dd/yyyy, but
I want the time as well. How do I get all of 2/28/20006 data? Any help
will be appreciated. Thank you in advance.
 
Change the criteria in your query so that it asks for less than the next
day.

Examples:
If your criteria currently reads:
[What Recd Date]
change it to:
= [What Recd Date] AND < ([What Recd Date] + 1)
Click to expand...

If you currently have:
Between [StartDate] And [EndDate]
change it to:
= [StartDate] AND < ([EndDate] + 1)
Click to expand...
 
Back
Top