I have an access report that produces a price list. I need to insert into the report a special section to cover retail products that are alredy in the price list these products are already shown in their respective categories and I need them to still be in their general category but if they have a secondary retail code also in this section. In the source table these product have a secondary code.
eg:
Pn Status
123 SP
124
125
126 SP
I need all the products with a status of SP to be in 2 categories.
eg:
Widgets
Widgets Retail
Regards
Errol Featherstone
eg:
Pn Status
123 SP
124
125
126 SP
I need all the products with a status of SP to be in 2 categories.
eg:
Widgets
Widgets Retail
Regards
Errol Featherstone