Add " mark to query results

[Laura]

How can I add quotaton mark to each result pulled from a query? We need to
upload the query results (email addresses) to Novell and it requires that
each result have a " mark at the end. I really do not want to manually add
each " tp 6000+ email addresses!
TIA

 

[Ofer]

In the query add to the fields before and after "''

'"' & [FieldName] & '"'

 

[Ken Snell [MVP]]

What does the SQL statement for your query look like? Post it and we can
suggest how to do it.

 

[MGFoster]

How can I add quotaton mark to each result pulled from a query? We need to
upload the query results (email addresses) to Novell and it requires that
each result have a " mark at the end. I really do not want to manually add
each " tp 6000+ email addresses!
TIA

SELECT email & '"' As email_address
FROM ... etc. ...