Displaying meaningful data rather than table linking data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am writing a query based on two tables. My query returns data but it is the
‘ID data or linking data’, just a number.

For example: How do I instruct the query to display TestReportLab
(meaningful text) rather than TestReportLabID (just a number)

There is a one to many relationship between the tables.

tblTestReports
TestReportID
TestReportLab

tblLabs
LabID (just a number)
LabName (text that means something)

This is my first attempt at a query so thanks for any assistance.

Seth
 
Open the query in design view, you will see the two tables linked to each
other.
Each table list all the fields that it contain, fron this table list you can
add any field that you want to the query, either by double click on the field
name, or by drag and drop.
 
But from the two tables shown, there is no linking field; i.e., there is
nothing in common between tblLabs and tblTestReports. Is TestReportLab
supposed to read TestReportLabID and be the same as the LabID in the other
table?
 
Back
Top