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.
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.
