Contains or Within Query

[MilinPCH]

I think this is an easy one, but I can't seem to find out how to do it.

Have a query against a field in a table that has multiple values...for each line item, the values in the field could be A or AB or even ABC or AGC or any combination of letters.

What is the syntax for the criteria section of my query to find line items from the table that just contain the letter B (even if it is part of the text string of other letters)

Thanks!

 

[jebry]

Hi!

In the criteria you need to use Like "B"

hth
Jeff Bridgham
bridgham@purdue.edu

 

[MilinPCH]

jebry,

That's what I did, but it comes up blank.
(I am using Access 02)

????????

 

[jebry]

Hi!

Well don't I feel foolish! Try Like "*B*"

hth
Jeff Bridgham
bridgham@purdue.edu