Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hello. (Access 2007)

    I'm constructing a pivot table based on a simple staff table, with salary, office, department, etc.

    I'm showing the minimum salaries within each office. How can I also show the maximum salaries within the same report?

    Thanks, Andy.

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    If You Right Click on the Salary Field in the Pivot Table do you not get offered AutoCalc as an option and Max should be in that.
    Andrew

  3. #3
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi, and thanks. When I did that the first time it showed as a second total within the same salary column. I just did it again and it initially
    displayed a separate salary column - so I had one for Min and one for Max (as required).
    I have a row area of Office; if I hide the details for this the max again becomes a separate column. Perhaps this is the way it is supposed to behave?
    Andy.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •