Print Records across the page -data is vertical

  • Thread starter Thread starter George
  • Start date Start date
G

George

I have a Table with three Fields (and more): Cost_Code,
Cost_Phrase, & Cost_Disc (124 Cost Codes...etc)
Sample: 1, Move, To move from one dept to another
2, Move Out, To move out of State..etc

I need a report grouped by Depart (a another related
Table) and then columns with one of the three fields:

Depart
Purchasing Move Move Out Hired Spent Fired
IT Move Out Hired Spent
Accting Hired Spent Fired

All the logic works great! Forms are great!
I tried Cross tabs & Pivot tables with no luck
How do you move Vertical data to the Horizontal?
 
The way I would do this is create one report with a
subreport for each of the departments, each of the
subreports would be a single crosstab query.
Without more specific information I can not give you more
specific help.
But it sounds like you are familiar enough to make this
work.
Hope this helps.
Fons
 
Back
Top