If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Change report layout
I have a report that shows Categories (01, 02 etc) and within each category
there are further subdivisions of letters (X, N, P et. al.) The report is laid out with a Category header, then the letters beneath and a count of how many records contain each letter has so it looks like this: 01 N 23 X 13 P 9 02 N 17 X 14 P 6 etc. I want to change the layout so the letters are across the top like so: N X P 01 23 13 9 02 17 14 6 How can I do this? Thank you! Ripper |
#2
|
|||
|
|||
Change report layout
Create a crosstab query with the letters as Columns and Categories as Rows.
Then create a crosstab report using the crosstab query as the recordsource. Steve "ripper" wrote in message ... I have a report that shows Categories (01, 02 etc) and within each category there are further subdivisions of letters (X, N, P et. al.) The report is laid out with a Category header, then the letters beneath and a count of how many records contain each letter has so it looks like this: 01 N 23 X 13 P 9 02 N 17 X 14 P 6 etc. I want to change the layout so the letters are across the top like so: N X P 01 23 13 9 02 17 14 6 How can I do this? Thank you! Ripper |
Thread Tools | |
Display Modes | |
|
|