Hello,
I am a noob access user. I have spent about an hour and a half using search in these forums and google and haven't been able to resolve my issue, so wanted to check with the experts to see if they can point me in correct direction.
I have a big table with product numbers listed along with inventory levels and other information. I am trying to write a basic query to enter a product number and pull a report up based on that query and show inventory etc.
I think the issue I am having is that product numbers don't have any specific format and have great variability in their length and characters used. I posted some examples below.
I am trying to write a query to have the "base number" get entered and then pull up a list of similar products.
The query I am using is: Like [enter_Material] & "*"
When the prompt comes up, I type in "B123456" and hope to get all results that start with that number. For some reason, the one with -BULK does not appear in my query results.
Thank you for looking at this, any suggestions are greatly appreciated.
An example of what the product numbers look like:
B123456-BULK B123456-10L B123456-5L B123456-1L B123456-15L B123456-200L A654321-BULK A654321-500G A654321-1KG A654321-2.5KG A654321-5KG A654321-12KG A654321-20KG A654321-50KG A234256 D1234-U 325067 P65124-BULK-F