Hello,
New here and to Access. I've taken a couple of classes and purchased a couple of books but still fairly lost.
I'm writing a query that will return quantity of 1" bolts. I have succesfully returned 1/2" and 3/4" bolts (like "*1/2* bolts*) and (like "*3/4* bolts*).
I have found out that when I imported my data from excel, I probably should have took notice of any special characters, especially " (inches) and # (wire size) as I have a lot of items with these characters.
That being said, I tried many combinations that are supposed to be only one wildcard in lieu of the ", but I cannot get the query to return only 1" bolts. (like "*1* bolts*) unfortunately returns 1/2, 1, 1 1/4 and 1 1/2.
Any thoughts?
Thank you,
Rob