Using a comma as criteria in a query

#1 January 7th, 2005, 12:46 AM

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

#2 January 7th, 2005, 01:53 AM

This should work:
Like "*,*"

--

Ken Snell
MS ACCESS MVP

"Robin Chapple" wrote in message
...
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

#3 January 7th, 2005, 02:01 AM

Ken,

100% correct. many thanks,

Robin

On Thu, 6 Jan 2005 20:53:00 -0500, "Ken Snell [MVP]"
wrote:

This should work:
Like "*,*"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Complex query criteria - desperate appeal	Ted Allen	Running & Setting Up Queries	5	November 17th, 2004 06:14 PM
Query criteria conflict	dunnotar02	Running & Setting Up Queries	6	November 9th, 2004 07:04 PM
Too Few Parameters error Mail Merge Access Parameter Query	Tony_VBACoder	Mailmerge	3	September 14th, 2004 12:15 PM
Print	Taher	Setting Up & Running Reports	1	August 31st, 2004 09:07 PM