In my report, I have to have 2 fields, one that's called previous department and the other is called new department for an employee.
That database stores this value in a field called A_Value.
My question is how can I have all this information displayed on 1 line?
Emp Old Dept New Dept
12345 93000 91204
Thanks for all you help guys