Parameters in Query

  • Thread starter Thread starter Anthony
  • Start date Start date
A

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
 
Anthony said:
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]
 
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:])
 
You might also try...
Where (form.Field >= [Beginning Date] OR [Beginning Date] Is Null)
AND (form.Field <= [Ending Date] OR [Ending Date] Is Null)
 
Back
Top