10-12-2004, 02:47 PM
|
 |
Centurion
|
|
Join Date: Jun 2003
Location: Bloemfontein
Posts: 183
|
|
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?
Code:
SQL = "SELECT * FROM Transactions WHERE fldClient= ' " _
& cboSelectedClient & " ' AND fldDate BETWEEN #" & DateFrom & "# AND #" & DateTo & "#;"
|
|
Linear Mode
