• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1066
  • Last Modified:

Access 2007 Report Showing ID (Primary Key) - How Can I Show Value?

I have a database with a handful of tables (all with a auto-number primary key). When producing reports from this I get the ID in the report rather than the value - how can I change this to display the value rather than the ID? (The query shows the actual value rather than the ID...)

I can't upload an example as it's Access 2007 and it's not allowed :-(
0
stehardy88
Asked:
stehardy88
  • 2
  • 2
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Use that field from the query as the Control Source for the text box which is now displaying the ID.

mx
0
 
stehardy88Author Commented:
The Control Sources are set as the correct fields. The record source for the Report is the Query.

I've stripped down and saved as Access 2003 version - please fin attached.

Ayy help would we gratefully welcomed.
example.mdb
0
 
Helen FeddemaCommented:
If this is a case where a field has a lookup to another table, you can place a combo box on the report to display the looked-up value instead of the key field.  (It will look like a textbox in Report View or Print Preview).  I tried to open your report, but just got a message "can't open Contact.png".
0
 
Helen FeddemaCommented:
Alternately, you can link in the tables that have the fields you want to display on the report, and then place those fields directly on the report.
0
 
stehardy88Author Commented:
Linked in fields from 4 tables that were causing problems. Changed the RecordSource to these fields in the query - started working correctly.

Cheers!
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now