query using a list 2

[mmsales]

I have imported an excel sheet to a table. One column has multiple entries separated by commas.ie: blum,adv,epi,kl
How do i get access to give me records that contain 'adv. FYI: some records have adv only in the field. I could get those with single entry, but need those with multi entry.
Thanks in advanced
mmsales

 

[PHV]

Something like this ?
WHERE (fieldX='adv' OR fieldX LIKE 'adv,%' OR fieldX LIKE '%,adv' OR fieldX LIKE '%,adv,%')

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[mmsales]

Could not get to work. Is there a way to do it using the query grid?

 

[jebry]

Hi!

On the criteria line put:

Like "*adv*"

hth


Jeff Bridgham
bridgham@purdue.edu

 

[mmsales]

Thanks jebry for this answer. Can I take it one step further? How can I get access to ask me the mfgr (ie: adv)and still have it look in the 'multi entry' field. I tried "like "*[get mfgr]*" and it gave me all of them. I am trying to print a list by mfgr.
thanks in advanced,
mmsales

 

[PHV]

Have you tried this ?
I tried Like "*" & [get mfgr] & "*"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[mmsales]

YES! It worked. Thank you!!!!!!
mmsales