SQL Example Needed?

Hi. Im using a Transaction Application.I am designing a form where the user can select the Customer and 2 Dates.How would my SQL Query look for this?

How would it look like if i need query the Customer name with the dates?

Is the following code correct?



SQL = "SELECT * FROM Transactions WHERE fldClient= ' " _
& cboSelectedClient & " ' AND fldDate BETWEEN #" & DateFrom & "# AND #" & DateTo & "#;"

Looks like you need to take a moment to read Basic SQL Query Statements.
SQL Tutorial (http://www.1keydata.com/sql/sql.html)