Add " mark to query results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
In the query add to the fields before and after "''

'"' & [FieldName] & '"'
 
What does the SQL statement for your query look like? Post it and we can
suggest how to do it.
 
Laura said:
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
Click to expand...

SELECT email & '"' As email_address
FROM ... etc. ...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to finding student Rank and How to upload bulk marks of each student at a time. 1
Combine Duplicates in Query 0
Make one final list from four sources 1
Query result displays NON selected fields 3
Run query based on results of previous query using code 4
Access 2010 append query to SQL is very slow 0
want show result in spread sheet, in the form 5
Three fields conditionally based on other fields 6

Back
Top