CODEWITHSUNDEEP
ms-access
FocusWiz
FocusWiz

Reputation: 533

Lookup Fields MS Access

I am somewhat new to MS Access and I have inherited an application with a table that uses this Lookup feature to replace a code with a value from a query to another table.

When I first used this table and exported it to Excel for analysis, I somehow got the base ID number (or whatever it would be called) rather than the translated lookup value. Now, when I do this, I get the translated text. The biggest problem is that while the base value is unique, the translated values are not, so I cannot use them for the work I am doing.

Can someone explain how to get the underlying ID value rather than the lookup value? Is there some setting I can use or some way to reference the field upon which the lookup is based. When I query the ID field, I get the lookup value. I know that the first time I did this, the spreadsheet contained the ID number not the text.

For now, I created a copy of the table and removed the lookup information from this copy, but I know I did not run into this when I did this the first time.

Thanks.

Upvotes: 1

Views: 543

Answers (1)

BankBuilder
BankBuilder

Reputation: 521

When you export to Excel, leave Export data with formatting and layout unchecked. This will create a spreadsheet with raw data values in Lookup fields.

Export settings image

Upvotes: 2

Related Questions