Query Problem?

[sapala]

I have a little problem with Access queries.

I would like to create query that allow user input start day and end day.

I can do it like this #>=1.1.2006#AND#<1.1.2007# this works but user cannot input itself date numbers

I think that is easy to create that query ask first start day(user input) then OK and then another ask end day then ok and that´s it

I hope that somebody can understand my bad language

 

[Michael J Ross]

I think what you want to do is put the following in your query criteria, the text in [ ] will prompt the user to enter the dates

>=[Start Date] And < [End Date]

 

[sapala]

Thanks very much Michail J Ross