Display column (2007)

Topic

New Reply

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!

Reply | Quote

Replies

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.

Reply | Quote

Thanks!!

Reply | Quote