[AccessD] Adding Quotation Marks

In the query grid:

	QuotedName: Chr(34) & [NameField] & Chr(34)

HTH,

Jim DeMarco 
Director of Product Development 
HealthSource/Hudson Health Plan 

-----Original Message-----
From: Terri Jarus [mailto:jarus at amerinet-gpo.com]
Sent: Tuesday, September 30, 2003 8:28 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Adding Quotation Marks


I need to set up a calculation in a Query that will take a field and surround it with quotation marks.  For example, Field1 has an entry - Terri Jarus.  I want to display it in another field as "Terri Jarus".

How do I do this?

Thanks for any 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. 


***********************************************************************************
"This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged.  If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited.  If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message.  Thank You".
***********************************************************************************