regarding a sql query in MS Acess

[Nemo]

Try this one


SELECT * FROM Orders WHERE (Orders.dateofreceipt>text1.text .and. Orders.dateofreceipt<text2.text)

make sure text1.text and text2.text are properly formatted to reflect dates.