-
Lookup fields in Queries
I have a lookup field in a table, and I'm trying to do a query. The query displays the record of the lookup field. How can I change the record to the name that is associated with that record.
UserID is the Lookup Field
UserID 34
First Name John
Last Name Doe
Query
display for record 34
John Doe
Last edited by sroyalty; 08-11-2003 at 04:16 PM.
-
If I'm reading you right, and you want it to display John Doe in one column thats quite easy actually. Simply put in a new column with the following in the first row:
FullName: [TableName].[First Name] & " " & [TableName.[Last Name]
That SHOULD work ... but then again we SHOULD have mourned the loss of one of the BeeGees back in the 80's ....
Let me know if it works for ya.
Brandon
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|