Pivot tables Excel vs Access

M

Mike Eyre

I am trying to create a pivot table in Excel to assign
exam grades in particular subjects to pupils. If I do
this in Excel all the grades are changed to the value 1.
If I do it in Access the grades are maintained - does
anyone have any idea why this should be handled
differently in these two office programs?
At present I have a table in excel which I have to export
to access to create the pivot table and then copy it
back. Surely I shouldnt need to do this every time?

Help!!!!!!!!
 
K

Ken Wright

To format as Debra has suggested, right click on any of the numbers, choose
field settings, hit the 'number' button and then choose your format.
 
G

Guest

The grades are letters A-G but when put into the pivot
table they change to the number 1.
 
D

Debra Dalgleish

The data area of a pivot table can't contain text, so the grade letters
won't show. You could move Grade to the Column area, and use another
field in the data area, e.g. StudentID. That would give a count of Grade
per student name.

In Access, you may have used a crosstab query to summarize the data. It
has First and Last functions, which do display text.
 
Top