Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Insert section into Access report

Status
Not open for further replies.

errolf

IS-IT--Management
Aug 21, 2000
51
US
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top