[AccessD] set field in a query

Drew Wutka DWUTKA at marlow.com
Wed Oct 15 11:28:24 CDT 2003


SELECT "Executive" AS MyField, NormalField
FROM tblMyTable

Drew

-----Original Message-----
From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com]
Sent: Wednesday, October 15, 2003 10:23 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] set field in a query


Using sql code how can make a field in a query to always equal a word
"Executive" ? (not coming from a table, the rest of the query is)


-----------------------------------------
Get Breaking News from CNN, ABC, NBC, CBS Now.
http://www.xuppa.com/news/?link=webmail


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list