[AccessD] Wrap a Field in ""

Terri Jarus jarus at amerinet-gpo.com
Mon Jun 30 14:16:31 CDT 2003


Nevermind - right after I clicked Send, it occurred to me to concatenate what I needed.  Got it - thanks anyway.
 
Terri Jarus
Director, Contract Support Services
jarus at amerinet-gpo.com
314-542-1902

>>> jarus at amerinet-gpo.com 06/30/03 02:13PM >>>

I want to take the information in Field2 and create another field with it wrapped in quotations marks.
 
For example, if the data in Field2 is 12345, I want my new field to display "12345"
 
I am doing this in a query, but just don't know how to get the quotations properly.  I keep getting something like "[Field2]"
 
Any thoughts?
 
Thanks for your help.
 
Terri Jarus
Director, Contract Support Services
jarus at amerinet-gpo.com 
314-542-1902

---------------------------------------------------------------------------
This email and any files transmitted with it are confidential and
intended solely for the use of the individuals or entities to whom they
are addressed. If you have received this email in error please return 
it to the sender, and erase any copies thereof.

Copyright 2003 AmeriNet 1nc. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030630/096b6d52/attachment-0001.html>


More information about the AccessD mailing list