SQL Statements

Is there a way of continuing the line whilst moving to the next line in an SQL statement. e.g.

Select * from "Table.name, Table.Address (cont)
Table.postcode, Table.Tel "

I am trying to do this within Access.

Comments

  • : Is there a way of continuing the line whilst moving to the next line in an SQL statement. e.g.
    :
    : Select * from "Table.name, Table.Address (cont)
    : Table.postcode, Table.Tel "
    :
    : I am trying to do this within Access.
    :
    Depends on where u write the SQL statement, if in VB do this:

    strSQL = "SELECT Field1, Field2, Field3 FROM TableA WHERE" & _
    " Criteria1 = '" & Text1.text & "'"


    Neo Gigs
    http://communities.msn.com.my/VisualBasicwithNeo

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion