SQL Example Needed?

10-12-2004, 03:47 PM
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 & "#;"

10-12-2004, 07:26 PM
Looks like you need to take a moment to read Basic SQL Query Statements.
SQL Tutorial (http://www.1keydata.com/sql/sql.html)

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum