Using a comma as criteria in a query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robin Chapple - 07 Jan 2005 00:44 GMT

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

Reply to this Message

Ken Snell [MVP] - 07 Jan 2005 01:52 GMT

This should work:
Like "*,*"

Signature

Ken Snell
<MS ACCESS MVP>

>I have a table which includes an field that sometimes has multiple
> email addresses separated by a comma.
[quoted text clipped - 10 lines]
>
> Robin Chapple

Reply to this Message

Robin Chapple - 07 Jan 2005 02:01 GMT

Ken,

100% correct. many thanks,

Robin

>This should work:
> Like "*,*"

Reply to this Message