If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Query help needed
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 |
#2
|
|||
|
|||
Query help needed
On Fri, 18 Jul 2008 19:05:53 -0700, dave wrote:
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. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
Thread Tools | |
Display Modes | |
|
|