Filter where criteria is contained in text string
in [Reports]
|
From: jay on 23 Apr 2010 19:59 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.
From: Al Campagna on 23 Apr 2010 20:16 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" <jay(a)okenconsulting.com> wrote in message news:A8CE4FCCCA51479C9C54CC0F86A69F48(a)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.
From: jay on 24 Apr 2010 00:42 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 [mailto:newsgroups(a)comcast.net] 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: Re: 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" <jay(a)okenconsulting.com> wrote in message news:A8CE4FCCCA51479C9C54CC0F86A69F48(a)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.
|
Pages: 1 Prev: Importing TXT files with delimiter Next: Event descriptions... |