Parameter Query Selection Problem
Posted on 2008-06-09
I have a database table with 12 item number fields (and each has a corresponding quantity field) in it. Each can be a different item number. (example: Item number 1, Quantity 1: Item number 2, Quantity 2, etc)Is there a way to create a query to select an item and qty using a parameter in the query not tied to any field and using this parameter to select all items that match this parameter? To further explain, lets say I want to select Item number 1111-04 from this table. Record 1 would have this item in the Item number 1 field and record 3 would have this item in Item number 4 field. I would want to select the matching items for this query and list each match separately or in total.