Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2005
    Location
    Denver, CO
    Posts
    100

    Unanswered: Field named "PAGE"

    I have a field named "PAGE" in one of my tables. Everytime I refer to it in a report, Access uses the built-in variable [Page] and displays the page number. How do I reference my field instead? Thanks!
    BillS

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Personally I'd rename the field. Have you tried....[tablename].[page]?

    Not sure if that'll work though.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Jun 2005
    Location
    Denver, CO
    Posts
    100
    I was trying to avoid that, but it's the best thing to do I guess.
    BillS

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    This thread will definately be worth a read
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •