Results 1 to 2 of 2

Thread: Access Queries

  1. #1
    Destiny7 Guest

    Access Queries

    What's the SQL statment that tells Access to Select the data from a certain field, but rename the field something else so that the field name doesn't display once the data is returned via the web. This SQL statement works w/Oracle but not Access:
    SQL_String = "SELECT "
    SQL_String = SQL_String & "ACREGN " + chr(34) + "REGISTRATION" + chr(34) + ", "

    Thanks Alot!

  2. #2
    Simon Longlands Guest

    Access Queries (reply)

    Try

    "SELECT ACREGN AS REGISTRATION

    Simon


    ------------
    Destiny7 at 3/1/2002 3:39:39 PM

    What's the SQL statment that tells Access to Select the data from a certain field, but rename the field something else so that the field name doesn't display once the data is returned via the web. This SQL statement works w/Oracle but not Access:
    SQL_String = "SELECT "
    SQL_String = SQL_String & "ACREGN " + chr(34) + "REGISTRATION" + chr(34) + ", "

    Thanks Alot!

Posting Permissions

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