I have not used queries or Access for a few years. I have a query set up to search for a tag number which the user enters in. How do I incorporate the * function in with it? This is what i have tried:
SELECT * From Bags_Recieved WHERE Tag_No = *" & [Which Tag?] & "*

I am trying to get it so the user just has to enter in a few numbers in case they do not know the whole number.

in your criteria grid for tag_No enter

LIKE "*" & [Which Tag?] & "*"