Thread: Cross-Tab query
View Single Post
 
Old March 2nd, 2008, 07:03 PM
subhanak subhanak is offline
Authorized User
 
Join Date: Apr 2006
Location: , , .
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default Cross-Tab query

Hi,

Is it possible to transform an Access cross-tab query to a table?

Example:

Cross-tab query returns:

Company South North West East
Comp1 10 11 12 14
Comp2 15 16 17 18
Comp3 19 20 21 22

I want to end up with a table which has the following fields:

Company
South
North
West
East

Thanks
Sayed

Last edited by subhanak; December 21st, 2009 at 10:50 AM..