How to Build SQL String

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.
 
K

Kevin

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List all tables, including document structure 0
Building SQL string 1
Creating a querydef of a stored proc on Sql Server 8
Numbered list problem 6
building a string in a public function 1
SQL string in VBA 4
Running Query in VBA 3
>> building a sql database from another sql database 2

Top