O'Reilly logo

Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills by Bob Schneider

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Concatenation

Chapter 7, “Find and Filter,” introduced expressions and how to construct them. In Chapter 9, “Queries, Part II,” you used the & operator in a parameter query but without explanation, which I promised to provide in this chapter. So here I review expressions and explain the & operator by answering this question: How does ="Page " & [Page] give you page numbers on every page?

Deconstructing the Expression

Let's look at each part of the expression:

  • You start with the = sign. In the text box of a report, you use this to tell Access to get ready for an expression.

  • Next is "Page ". When you viewed the page numbers in Print Preview (Page 1, Page 2, and so on), each began with Page. This is a text string that Access prints exactly ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required