Results 1 to 2 of 2

Thread: Lookup fields in Queries

  1. #1
    Join Date
    Aug 2003
    Location
    Kentucky
    Posts
    1

    Question 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.

  2. #2
    Join Date
    Jun 2003
    Location
    Bloomington, IN, USA
    Posts
    116
    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
  •