Howdy, Stranger!

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

Categories

SQL Statements

Dave101Dave101 Member Posts: 10
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

  • gigsvoogigsvoo Member Posts: 328
    : 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

  • Chris BrownChris Brown USAMember Posts: 4,624 ✭✭

    _ // http://forcoder.org // free ebooks and video tutorials about < Scratch, Java, PL/SQL, Visual Basic .NET, Swift, R, Assembly, PHP, Objective-C, JavaScript, Perl, Ruby, C, Visual Basic, Go, C#, MATLAB, Python, C++, Delphi Prolog, Lisp, Fortran, Awk, ML, Julia, Scheme, D, Bash, Clojure, Dart, Logo, F#, Apex, Lua, Transact-SQL, Alice, Crystal, Scala, SAS, Erlang, Hack, VBScript, LabVIEW, Kotlin, COBOL, Rust, Ada, ABAP, FoxPro /> ___________

Sign In or Register to comment.