Multiple Unique data on each Page of a report

  • Thread starter Thread starter Jan Williams
  • Start date Start date
J

Jan Williams

Hi,

I'm using acess 2003 and designed a database to input and print show tickets.
Each ticket has a unique Row and Seat Number printed on it. This database
containes only 3 fields. They are "Section", "Row" and "Seat". I've created
a report that is in the design of the ticket to be printed. I want to pirint
4 tickets per page and of course each one of the tickets needs to be unique.
My problem is that all four tickets that print on the page has the same Row
and Seat Number. On the next page the data increments but again all four
tickets on the second page is the same. Is there a way to format so that
each ticket on the page is unique and increments per the data? If so, how
can I accomplish this.

Thanks for your help.

Jan
 
Don't print a (normal) report - print a lable

There is a lable report wizard if you need - or just design you "report" so
it is about a quater of the page size (maybe A6) then go to page setup (on
the file menu) and selet the columns (2) and rows (2)

Good luck
 
Back
Top