Query help needed

[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

 

[fredg]

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

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.