A ABP New member Local time Today, 17:55 Joined May 16, 2008 Messages 5 May 20, 2008 #1 Is it possible to convert an Access 2002 pivot table into a query?
Dennisk AWF VIP Local time Today, 17:55 Joined Jul 22, 2004 Messages 1,649 May 20, 2008 #2 I thought a pivot table was a query. Its called a cross tabulation in Access speak. You could use a pivot table as a record source for a query though.
I thought a pivot table was a query. Its called a cross tabulation in Access speak. You could use a pivot table as a record source for a query though.
A ABP New member Local time Today, 17:55 Joined May 16, 2008 Messages 5 May 20, 2008 #3 At present it appears as an alternative way of viewing the table. I wish I could just right click it and be able to view the SQL which generates the data then copy it into a fresh query.
At present it appears as an alternative way of viewing the table. I wish I could just right click it and be able to view the SQL which generates the data then copy it into a fresh query.
DCrake Remembered Local time Today, 17:55 Joined Jun 8, 2005 Messages 8,626 May 20, 2008 #4 Simple Software Solutions If you go into the QBE and select SQL mode to view the sql statement.