Report showing ID numbers only

  • Thread starter Thread starter ema
  • Start date Start date
E

ema

I have tables set up, linked properly, forms, etc. Since I did forms and
subforms, I had to create separate tables and link them, so I used a primary
key ID in the tables. So far my database shows it is working - when
information is entered into the form, it shows up in the correct tables and
all that, but since I used all these primary keys, the tables just have a
bunch of the numbers that pertain to what was input rather than actual words.

I created a query with the fields that I want shown in the report, and I
created the report and when I run it it shows up the correct fields I want,
but it shows all the ID numbers. I want it to be translated to the words that
the ID keys represent. How can I change this?
 
ema said:
I have tables set up, linked properly, forms, etc. Since I did forms and
subforms, I had to create separate tables and link them, so I used a primary
key ID in the tables. So far my database shows it is working - when
information is entered into the form, it shows up in the correct tables and
all that, but since I used all these primary keys, the tables just have a
bunch of the numbers that pertain to what was input rather than actual words.

I created a query with the fields that I want shown in the report, and I
created the report and when I run it it shows up the correct fields I want,
but it shows all the ID numbers. I want it to be translated to the words that
the ID keys represent. How can I change this?
Click to expand...


Before creating a report, you should create a query that
returns the desired data. In this case, it sounds like the
query shoulf include the tables with the text joined on the
ID number fields.

If that's a valid analysis, then just add the needed tables
to the query and make sure the connecting lines are between
the appropriate fields in each pair of tables. Then you can
drag the text fields from their table to the query's field
list. Switch the query to sheet view to verify that it
presents the data you want to see in the report. Keep
working on the query until it works the way you want, then
use the query as the report's record source and away you go.
 
Back
Top