S
S K Srivastava
In access 2000 I use to create the pivot form which use to appear as excel
sheet embedded in the access form. I was able to pivot reports from that
sheet. In access 2007 when we try to create pivot table a different form view
is generated. Though the names are same but pivot table in access and in
excel are quite different. There is no way you can generate pivot report in
access. The functionality of creating excel pivot sheet in access form was a
very useful tool.
Can some one suggest me some round about way to achieve the same.
I am able to generate the pivot report in excel by linking it to the tables
in excel but then I have to take two file together ie one acess and other
excel. I want the excel sheet to be embedded in the main file itself.
sheet embedded in the access form. I was able to pivot reports from that
sheet. In access 2007 when we try to create pivot table a different form view
is generated. Though the names are same but pivot table in access and in
excel are quite different. There is no way you can generate pivot report in
access. The functionality of creating excel pivot sheet in access form was a
very useful tool.
Can some one suggest me some round about way to achieve the same.
I am able to generate the pivot report in excel by linking it to the tables
in excel but then I have to take two file together ie one acess and other
excel. I want the excel sheet to be embedded in the main file itself.