How to fix this Criteria

[abcman]

Hi All, How can I write this in a query - Criteria :

LIKE [Enter Date ?] = BETWEEN [Date_In] AND [Date_Out]

Please note that Date_In and Date_Out are fields and I want the query to ask me a date and then if it is within both in and out it will give me the record. I tried this sentence but Access is not accepting it. Am i making a mistake in pronouncing it ?. Thanks a lot

 

[bob fitz]

Try:
BETWEEN [Date_In] AND [Date_Out]

 

[abcman]

This is not my question. I know what you have proposed. I want to key in a date and the computer checks as a criteria if it is available between in and out.

Hope for everybody help. Thanks.

 

[gemma-the-husky]

you probably wouldn't put it in a query

you would probably check the date by code in some way, and then run the query if the date is acceptable.

 

[abcman]

Thanks. Someone told me that it works this way but I need to re-formulate this in a way that Access would accept it.

Can Some expert please provide a hand of help. Thanks.