Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cross Tab - Not listing Data

Status
Not open for further replies.

sprog

IS-IT--Management
Sep 12, 2002
48
NZ
Hi
I am trying to make a table using "Cross Tab". The columns are names of unions and the rows are the cost centre of each employee.

I want all the people from one cost centre in a particular column to be listed, but when I finish the report, I only get one employee's name in the data field. (the computer wants to sum or count - but I just want it to list everyone that fits both areas).

Any help would be appreciated.

 
Try adding the employee ID or name as an additional row field.

-LB
 
Thanks, this worked - Much Appreciated. Sorry about posting twice. Thought I wasn't going to get an answer on the first Forum. Will only post once in future.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top