-
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!
-
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!