Hi.
I'm making a report for a comic book collection using only two fields, title (the title of the series of the comic book, i.e. Avengers) and issue (i.e., 1, 2, 3, etc, - the issue number of the comic book within the series title) .
I would like to display the title, skip a line, then show all of the issue numbers in rows (across then down).
When the issues within a title are all displayed, I would like to skip a line, print the next title, skip another line and then print all of the issues within that title, across and then down, and then keep going like that until there are no more titles.
Sample:
Avengers
103 108 121 134 154 155 156
162 167 184 189 190 191 202
206 209 211 212
Fantastic Four
111 113 114 115 117 120 121
122 123 127 129 130 134 135
137
X-Men
109 115 117 118 119 125 125
127 128 129
I'm using Access 2007
I tried using page setup/columns. That prints everything out in rows including the title.
In a nutshell, I haven't been able to get blank lines displayed around the title when it changes, the title field is mixed into columns with the issue numbers.
I've tried searching online and in the doc but haven't found an answer.
Thanks for any help you can provide.
Charlie