Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2012

    Unanswered: Summary of calculated cross tab query

    I've got a db which stores employee details, hours worked for different company departments, the different rates of pay each dept pays and want a report showing each employee and pay for each department inside a certain pay period.

    I've created a cross tab query (as per attached screen shot). The pay per catagory is calculated using an expression in the query which seems to work correctly. Where I'm stuck is simply that I want the query to show each employee on a single line with entries against all the different departments. As you can see each entry is currently showing up on a different line which despite trying to play with the group by setting I can't get round.

    Attached Thumbnails Attached Thumbnails Capture.JPG  

Posting Permissions

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