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.