One quick simple question.

[Jason1]

I need to know what to enter into the critera area on a query. I am trying to include all of the records that have a certain word in the discription field. To explain, the discription field contains different part numbers, some start with A and some start with B. (a12, a45, ect.) I want to return all of the part numbers that have B in them. I'm using access 2007 thanks.

 

[plog]

To get all the records with a 'b' in them anywhere you would enter this:

Like "*b*"

To get all the records that begin with b you would use this:

Like "b*"

 

[Jason1]

thanks for the quick response.

Is there any reason why this wouldn't work with the letter A? If you use the letter O it works great, but the word ALI doesn't work, and neither does just the letter A. It returns nothing.

Thanks

 

[Jason1]

PLOG,

I figured it out. It was trying to display the product code as opposed to the description. The description started with A, but the product code started with C. When I used Like "C*" I got what I wanted.

Thanks for the help
Jason