quotes around data in a report

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

How can I get quotes around my data fields in a report? I am trying
to use Access to produce formatted data to be imported into a CAD
program. Below is a sample of how a data record should look in the
report. Note the quotes which surround the some of the text data.
Thanks.

map_objects_by_name->
ECAD_NAME "CB7000"
ECAD_ALT_NAME "37Z10006"
ECAD_TYPE ""
MCAD_NAME "CB7000"
MCAD_TYPE "part"
END
 
Hi ,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

If you wanted qutoe marks around a value from a field, you would use a
syntax similar to the following:

Chr(34) & [FieldName] & Chr(34)

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support
 
Hi ,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

If you wanted qutoe marks around a value from a field, you would use a
syntax similar to the following:

Chr(34) & [FieldName] & Chr(34)

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support
Click to expand...

Thanks Dennis. I found a way to do it, but your solution is simpler.
I will give it a try.

Bill
 
Back
Top