Query using 'start' & 'end' date parameter

7 Aug 2006 12:42 PM

pickles

Hello,

i've created a query that produces all the data held in my database and
i've set up a parameter - 'Between [Enter start date] and [Enter end date]'
to return only the data received between two specific dates however, when i
run the query it still returns all the data held in my database, not the
dates i am requesting. Can anyone help at all?

7 Aug 2006 2:35 PM

Lynn Trapp

Are your dates of data type TEXT?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

Show quoteHide quote

"pickles" <pick***@discussions.microsoft.com> wrote in message
news:E424432F-7FD5-4201-B123-91B823BD97BA@microsoft.com...
> Hello,
>
> i've created a query that produces all the data held in my database and
> i've set up a parameter - 'Between [Enter start date] and [Enter end
> date]'
> to return only the data received between two specific dates however, when
> i
> run the query it still returns all the data held in my database, not the
> dates i am requesting. Can anyone help at all?
>

7 Aug 2006 7:02 PM

S Panja

Ensure your data type is Date and that the dates in your query are enclosed
in hashes.

--
***************************
If the message was helpful to you, click Yes next to Was this post helpful
to you?
If the post answers your question, click Yes next to Did this post answer
the question?

Show quoteHide quote

"pickles" wrote:

> Hello,
>
> i've created a query that produces all the data held in my database and
> i've set up a parameter - 'Between [Enter start date] and [Enter end date]'
> to return only the data received between two specific dates however, when i
> run the query it still returns all the data held in my database, not the
> dates i am requesting. Can anyone help at all?
>