If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Filter where criteria is contained in text string
My reports Record Source has a concatonated field. I need to filter
where my criteria is one of the concatonated items. For example, my field called Groups may have "Foxmoor, Senior". I need to filter where the group field contains "Foxmoor". Any suggestions would be appreciated. |
#2
|
|||
|
|||
Filter where criteria is contained in text string
Jay
Your initial post appoears to be in HTML format. As far as I know, Plain Text format is used in these newsgroups. No big deal... just a head's up... http://www.mvps.org/access/netiquette.htm Let's say your string is named [Location] Then... Like "*" & "Foxmoor" & "*" or Like "*Foxmoor*" would find "Foxmoor" anywhere within [Location]. -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "jay" wrote in message news:A8CE4FCCCA51479C9C54CC0F86A69F48@JayPC... My reports Record Source has a concatonated field. I need to filter where my criteria is one of the concatonated items. For example, my field called Groups may have "Foxmoor, Senior". I need to filter where the group field contains "Foxmoor". Any suggestions would be appreciated. |
#3
|
|||
|
|||
Filter where criteria is contained in text string
Thanks. This worked fine. Also, I will check my email client settings as
this is the first time anyone has brought up the HTML issue. Thanks again. -----Original Message----- From: Al Campagna ] Posted At: Friday, April 23, 2010 5:16 PM Posted To: microsoft.public.access.reports Conversation: Filter where criteria is contained in text string Subject: Filter where criteria is contained in text string Jay Your initial post appoears to be in HTML format. As far as I know, Plain Text format is used in these newsgroups. No big deal... just a head's up... http://www.mvps.org/access/netiquette.htm Let's say your string is named [Location] Then... Like "*" & "Foxmoor" & "*" or Like "*Foxmoor*" would find "Foxmoor" anywhere within [Location]. -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "jay" wrote in message news:A8CE4FCCCA51479C9C54CC0F86A69F48@JayPC... My reports Record Source has a concatonated field. I need to filter where my criteria is one of the concatonated items. For example, my field called Groups may have "Foxmoor, Senior". I need to filter where the group field contains "Foxmoor". Any suggestions would be appreciated. |
Thread Tools | |
Display Modes | |
|
|