Results 1 to 3 of 3
  1. #1
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Display column (2007)

    Trying to display a new column in a query based on the second column of an existing field. I've done this in a form before, but never a query.
    I've tried =GGL.column(2), but no go. I want to display the "name" instead of the "ID" in a seperate column. Thanks in advance for any help!
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Display column (2007)

    You can't do it that way in a query.

    Add the relevant table (the one with the IDs and names) to the query.
    Join it on the ID field to the original table.
    Double click the join line.
    Select the option to return all records from the original table, then click OK.
    Add the name field from the added table to the query grid.

  3. #3
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Display column (2007)

    Thanks!!
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •