Parameters in Query

[Anthony]

I have a query and there is a trans time field and it is in the form of
7/22/2008 8:30 PM and I would to make a parameter query that asks you for
the start date and end date to search within. I have it set up know as
<=[Enter Date] and if I would put in 7/22/2008 it would list from 7/22/2008
and back. I just want the day I entered I tried the Between expression and
it is giving be blank results. Any help would be great.

Thanks

 

[Bob Barrows [MVP]]

I have a query and there is a trans time field and it is in the form
of 7/22/2008 8:30 PM and I would to make a parameter query that asks
you for the start date and end date to search within. I have it set
up know as <=[Enter Date] and if I would put in 7/22/2008 it would
list from 7/22/2008 and back. I just want the day I entered I tried
the Between expression and it is giving be blank results. Any help
would be great.

Thanks

between [Enter Start Date] And [Enter End Date]

 

[John W. Vinson/MVP]

I have a query and there is a trans time field and it is in the form of
7/22/2008 8:30 PM and I would to make a parameter query that asks you for
the start date and end date to search within. I have it set up know as
<=[Enter Date] and if I would put in 7/22/2008 it would list from 7/22/2008
and back. I just want the day I entered I tried the Between expression and
it is giving be blank results. Any help would be great.

Thanks

Try

BETWEEN [Enter date:] AND DateAdd("d", 1, [Enter date:])

 

[Rus925]

You might also try...
Where (form.Field >= [Beginning Date] OR [Beginning Date] Is Null)
AND (form.Field <= [Ending Date] OR [Ending Date] Is Null)