How to Build SQL String

  • Thread starter Thread starter Steve Crowhurst
  • Start date Start date
S

Steve Crowhurst

I'm looking for easy examples of how to build an SQL that
can be used to provide the functionality behind an QBF.
I'm running Access 2002 and DAO.
I'm struggling with the basic syntax and would therefore
appreciate some help. Thank You.
 
The easiest way to build SQL strings is to create the
query in the QBE Grid and then switch to SQL view. Then
copy the string from there into your code. The code
generated there typically has extra parenthasis, table
references that are not necessary etc., but it's
functional and simple.

Hope that helps!

Kevin
 
Back
Top