Printing the same report over multiple pages with page numbers (1 Viewer)

Hi All - Very new to the world of access so please excuse any simple questions.

I have a database which I have made which has only 2 tables, an account number and name of hotel.

I have a report that is generated by the user entering the account number into a search box. The report displays the name of the hotel and a print button.

The idea is that the user can print the report (only hotel name) onto a label with the name of the hotel followed by page 1 of 5, 2 of 5, 3 of 5, ect... depending on how many labels they want printed.

I have managed to get it to display 1 of 1 with the following code:

="Page " & [Page] & " of " & [Pages]

This however does not change if I try and print more then one.

Do you think what I am trying to achieve is possible?

many thanks

Will.

I just found this post in the newly added 'Unanswered Topics' link
I'm sorry that nobody has replied after 3 weeks.

I don't think there is anything inherently difficult in what you want but perhaps its not quite clear to forum users exactly what you require.

3 questions:
a) Why is there a Print button on your report?
Reports are not normally intended to be interactive. The button should be on a form
b) Is each label a full page e.g. A4 or are there several labels per page
e.g. Avery L7160/7163 type?
c) Are you trying to print several copies of the same label or 1 copy of several labels?