Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access reporting

ResolvedVersion 2007

Alan has attended:
Access Introduction course
Access Intermediate course
Excel Intermediate course

Access reporting

How do you add the page X of X in a footer - I think it was called concactination - I need to use it in Word as well as Access

Edited on Mon 27 Apr 2009, 18:17

RE: Access reporting

Hi Alan

Concatenation is used to add the page numbers in a report footer. The code is as follows:

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

However in Microsoft Word you don't need to use Concatenation to add a page number to a footer.

Access tip:

Space marks

It is good practice not i to have space marks for field names as this can lead to problems when using queries or VBA code. It is much better to use an underscore charcter to represent spaces in field names

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.