save access pivot table view as new table

  • Thread starter Thread starter Govardhan
  • Start date Start date
G

Govardhan

Hi,

1. Is there a way to save Access's pivot table view as a new table.
I'm using access 2003

2. Also is there a way to define the option provided in excel pivot
tables "For empty cells, show" in Access Pivot table view OR in the
cross-tab qery?
 
For the first option you could use a maketable query. But remember a pivot is
dynamic so the next time you could have more or less columns. So if you want
to use the outcome you have to run the maketable query with every change made
in the underlying data.
For point 2 I'd advice you to look for the option to add a 0 for the null
fields. It's being posted regularly in the queries newsgroup here.

hth
 
Back
Top