I need to print a report but I need to do it in a specific way that I have NO idea how to get.
I have 4 columns with the data in them.
Column A needs to be sorted in ascending order.
Column B needs sorted in ascending order after Column A.
Column C needs sorted in ascending order after Column B.
Column D holds the tricky part of the report.
The data in Column C is sometimes a repeat of the data in the field above. (lets say that column c, row 9 is 6, and row 10 is also 6) Column D would (in the same rows) would be NE (row 9) and NW (row 10).
I need my report to group the "same" data together with Column D lined up beside it.
i.e. 6 - NE - NW
6 being Column C and NE - NW being from Column D.
Is any of this making sense cause I have no clue if Im explaining it clearly!
Jim
I have 4 columns with the data in them.
Column A needs to be sorted in ascending order.
Column B needs sorted in ascending order after Column A.
Column C needs sorted in ascending order after Column B.
Column D holds the tricky part of the report.
The data in Column C is sometimes a repeat of the data in the field above. (lets say that column c, row 9 is 6, and row 10 is also 6) Column D would (in the same rows) would be NE (row 9) and NW (row 10).
I need my report to group the "same" data together with Column D lined up beside it.
i.e. 6 - NE - NW
6 being Column C and NE - NW being from Column D.
Is any of this making sense cause I have no clue if Im explaining it clearly!
Jim
