Insert section into Access report

[errolf]

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

 

[KenReay]

Hi

Base your price list report on a union query, which selects the products list (in total) plus the 'special items' again.

Without knowing you table names etc, I cannot give the exact SQL, but you need something like

SELECT Product, Description, Price FROM tblPrices
UNION
SELECT Product, Description, Price FROM tblPrices
WHERE Type = "Special"
ORDER BY Section Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK