Surrounding a field with quotes i.e. "Name"

[sales@scantechintl.com]

Hi,

I need to make a new table from an existing table. Each field in the output table must have a leading and trailing quote. I tried to surround the quotes with quotes (" " ") Acess says it's invalid.

For example: NewOutput: " '' " & [CustTable]![FirstName] & " " ".

This does not work.

Any ideas.

Thank you,
John

 

[Jon K]

Try this:

NewOutput: ' " ' & [CustTable].[FirstName] & ' " '
.