Totals in Pivot Table Using Access Data Page

A

AJCB

Hi,

Would someone be able to help me?

I am trying to create a pivot table in an Access Data Page, which adds a
grand total.
However, instead of showing:

1123456 125 126 127 128 129 : 634

It shows:

1123456 125 126 127 128 129 : 125
126
127
128
129

Also, when I try to add another field into the section to the left of data,
it adds another total column which I cannot get rid of. Ie:

123456 blister1
total:

I am using Office 2003 if that helps.

Regards
AJ
 
B

Buster Walker

AJCB said:
Hi,

Would someone be able to help me?

I am trying to create a pivot table in an Access Data Page, which adds a
grand total.
However, instead of showing:

1123456 125 126 127 128 129 : 634

It shows:

1123456 125 126 127 128 129 : 125
126
127
128
129

Also, when I try to add another field into the section to the left of
data,
it adds another total column which I cannot get rid of. Ie:

123456 blister1
total:

I am using Office 2003 if that helps.

Regards
AJ
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2007 Pivot Table 5
Prevent duplicate groups of records in a table 1
MS Access and Web Pages 1
Is there a way of not showing zero totals in a pivot table? 2
Creating multiple rows of data from a Quantity value in a table 4
Referencing a pivot tables Grand Totals Column 1
Pivot Table - copy specified Grand Totals 1
#### in Access Pivot Tables 3

Top