Capturing start date and end date in query

[srajesh]

Hi all
I have a date field in a table.
In a query, I want to capture the startdate and enddate. However when I select the date field in two separate columns in the QBE grid and give [enter start date] & [enter end date] in criteria, the query on processing clubs the two and converts it into "Between [enter start date] And [enter end date]" in the criteria.
Thus I am not able to capture "start date" & "end date" separately. How do I prevent the clubbing the criteria in the query.

thanks for the help

S Rajesh

 

[Guus2005]

its clubberingtime!

What do you mean by clubbing?
Could you post a sample database?