Query help needed

  • Thread starter Thread starter dave
  • Start date Start date
D

dave

Access 2003

I have a field (Forman) in a table which is a lookup to another table. I an
storing the ID not the name.


When I use the field in a query for a report it gives me the ID (column 1),
and not he name (column 2).

Is there anyway in the query (In the "Field" row) to call the name (column
2)?

Hope that makes sense.


Thanks

dave
 
Access 2003

I have a field (Forman) in a table which is a lookup to another table. I an
storing the ID not the name.

When I use the field in a query for a report it gives me the ID (column 1),
and not he name (column 2).

Is there anyway in the query (In the "Field" row) to call the name (column
2)?

Hope that makes sense.

Thanks

dave
Click to expand...

And the actual table and field names are??????

In the query, you need to include both tables (and make sure there is
a relationship set between them ... between the ID field in the one
table and the stored ID in the other table).
Then instead of using the [ID] field, use the [Name] field in the
query.
 
Back
Top