Using a parameter query with date and time

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alex Martinez - 21 Mar 2006 06:08 GMT

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.

Reply to this Message

Allen Browne - 21 Mar 2006 06:21 GMT

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)

If you currently have:
Between [StartDate] And [EndDate]
change it to:
>= [StartDate] AND < ([EndDate] + 1)

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> 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
[quoted text clipped - 3 lines]
> 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.

Reply to this Message