G
Guest
My query works great for entering information in two fields in the criteria
row and I get the data that I want. When I run the query it asks for a base
number and then a supplier code, I click run and it returns the data that I
want. I have a table with a couple of hundred base numbers and supplier
codes. I do not want to do them one at a time. My item field criteria in
the current query looks like this:
Like "*" & [Enter Base Number] & "*" and then the supplier code field
criteria is: [Enter code].
How do I pass each row in the table over to the query? Is that possible
with this setup? If you need more information let me know.
row and I get the data that I want. When I run the query it asks for a base
number and then a supplier code, I click run and it returns the data that I
want. I have a table with a couple of hundred base numbers and supplier
codes. I do not want to do them one at a time. My item field criteria in
the current query looks like this:
Like "*" & [Enter Base Number] & "*" and then the supplier code field
criteria is: [Enter code].
How do I pass each row in the table over to the query? Is that possible
with this setup? If you need more information let me know.