Newbie Question - Excel Reports

[tezzer]

Apologies for the newbie question - would someone be kind enough to explain how I generate an Excel report that includes all details for orders placed, including the products purchased and delivery details? So far I've managed to export everything BUT these details!

Thanks
Terry

[tezzer]

Actually, I think I've got this - just to check, there's no master report, they're all searate, is that right? (Ie orders, buyers etc). By the looks of it I'll be putting my VLOOKUP skills to the test in Excel....

[Duncan Rounding]

If you want to get down and dirty you can get the details from Actinic using Access. The three tables: Order, Order Detail & Person contain what you want - you can link to these tables from Excel by Importing External Data if you haven't got Access.

[tezzer]

Brilliant, Duncan - thanks so much - I'll go and find those access files!

Terry