Let me attempt to simplify my question even more. I thing I am not using the correct terms.
What I have is a form that looks like:
Qty Product Price Serial #
1 AA 102 Product $1,234.34 4374-1
4 DD 123 Product $1,133.22 5612-1
3 AM/FM Radio $0
In my example, “Product” is actually three fields (Product-1, Product-2 & Product-3) in my Customers Table. I also have a Pricing table where I am retrieving my List price in the Query. What I am attempting to do via a Query is create a report that would combine the information from the Product fields (Product-1, Product-2 & Product-3) and produce the following:
Qty Product UnitPrice ListPrice Serial #
1 AA 102 Product1 $1,234.34 $1,000.00 4374-1
4 DD 123 Product2 $1,133.22 $1,050.00 5612-1
5 $2,367.56 $2,050.00
The key point – I am trying to filter some information. In the example above, I would not need to see “AM/FM Radio” – but I would need all the products that are listed as ?? ??? (two characters space and three characters). This is generally the format of my product codes.
I have been able to create is a Report that that groups my different fields. But, I have not been able to filter the information I do not want. Currently, I get blank entries and some information I do not want. I am not sure if I accomplish this in my Query or the Report?