1. I have a form and a table AAA.
The user will input the start date and the end date in 2 text boxes in the form. TEXT1 and TEXT2 for example. Then I want to use these 2 dates to select the record in the table AAA by calling a Query. I don't know how to set in the Query desinger.
SELECT *;
FROM AAA;
WHERE AAA.date = ???

2. And I have tried to run
WHERE AAA.date = "1999/01/01"
The error message is "Operator and Operand mismatched."
What format should I use for the date?