Using a comma as criteria in a query

R

Robin Chapple

I have a table which includes an field that sometimes has multiple
email addresses separated by a comma.

I need to select these from the database and expected to use the comma
as a criteria. An error message has advised to include the text in
quotes but that did not work either.

I expected to use *,*, I have changed to *","* which also fails.

How is it possible?

Many thanks,

Robin Chapple
 

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

Format change in merge data - Bold formatting after a comma 0
Excel does not accept text format! 0
Is this possible? 0
Formating bolded text exclusively. 0
Dynamic Naming of Form Button 3
Problem with SET & REF function 0
Use a variable in a ShapeRange.Increment 0
Have 4 email addresses Want to auto forward all in one of them 0

Top