Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2005

    Unanswered: Reports displaying Keys

    I am trying to create a report using a query, but the output of the report shows the key instead of the name field that should display when I group using that field. How can I get the proper field name to display vs the key?


  2. #2
    Join Date
    Nov 2004
    I think you are exposed to some of the reasons why most of us recommend against "table level lookup fields". See for more info

    Also, have a look at "10 commandments", which you'll find linked at the left

    What you need to do, is to enter the query again, and ensure the table from which that name originates, is added to the query, then also add the name field to the query grid. Use this field afterwards in the report.

Posting Permissions

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