Record for current month

[Zoom1234]

Hi,

How can i get a record for startdate < currentdate and enddate > currentdate ?
Is there any built in function in ACCESS ?

Thanks

 

[SkipVought]

Zoom1234,
[tt]
Select *
From YourTable
Where startdate < Date and enddate > Date
[/tt]


Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244

 

[Zoom1234]

Thanks SkipVought,
However i am not getting desired result. I may be doing something wrong.

My startdate is 6/10/2004 (ie 6th July). however the query
where startdate < date is not displaying the above record.

Any suggestions ?

 

[Zoom1234]

Thanks SkipVought,
However i am not getting desired result. I may be doing something wrong.

My startdate is 6/10/2004 (ie 10th July). however the query
where startdate < date is not displaying the above record.

Any suggestions ?

 

[PHV]

What is the value of enddate ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[willir]

Zoom

Is this an unbound combo box? How are you controlling what records are being displayed?