Using multiple tables for pivot tables

[rjc08]

Hi I'm fairly new to Access, and I have this report to write and am running out of time. So please bear with me as I may have several threads starting up soon.

I have several tables and I want use a pivot table, but I want to use data from different tables.

Can someone help me with this?

 

[Premy]

U mean pivot query? The Northwind sample DB has an example of a pivot query. Might help u get on the right track.

HTH