Parameters in Query


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
 
Ad

Advertisements

B

Bob Barrows [MVP]

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]
 
J

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:])
 
Ad

Advertisements

R

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Consecutive Query 5
top 5 days for each user 12
fixes date column 1
date quieries 1
GET SINGLE ROW ORDER BY LATEST DATE. 1
Query using date range entered by user 2
Most recent date 1
need a query 1

Top