Results 1 to 15 of 15

Thread: [RESOLVED] Going Crazy 2 - The SQL

Threaded View

  1. Nov 22nd, 2007, 02:59 AM #1
    jhize
    jhize is offline

    Thread Starter
    Lively Member jhize's Avatar
    Join Date
    Dec 2006
    Posts
    87

    Resolved [RESOLVED] Going Crazy 2 - The SQL

    OK. I understand that the punctuation is critical in SQL statements but, come on:

    Code:
     Sql = "SELECT Occupant, Telephone#, EmergencyContact, EmergencyCntNum FROM Occupant WHERE PropertyCommonName = '" & Propertyname & "'"
    The only field I don't want returned is PropertyCommonName.....and it's just not cooperating.

    I have seen examples that use SELECT Table1.Field1 as field That doesn't cut it either.

    Can anyone see what I can't here?
    Last edited by jhize; Nov 22nd, 2007 at 06:43 AM.
    The question is not, Can I?
    The question is, How Do I?

    SQL Syntax | More SQL
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width