Export to Excel - Lookup Field ID vs Value

[herverob]

Hi all,
I am having a little problem with an export to XL.
I have created a tbl in which some field are lookups to other tbl.
I have created a qry (that is a copy of that tbl).
When i export that qry in XL, i am getting the fied ID instead of the Field Value!
Anyone have a clue how i can sort this out?

Cheers
Herve

 

[herverob]

attached problem

hi,
for a better understanding of my problem, I have attached a sample of my DB.
A click on the button creatres a XL file on the C Drive but in column B, I would like to get the Value and not the Reference of the field (exactly the same as Query3).

PS: Does anyone know how to attached the code in a Thread?

Thanks
Herve

 

[herverob]

Attached Solution

Hi all,
Problem solved!
I was doing a lookup on a Number instead of a Text!

I like this forum,
you pose your Problem,
you still work on your Problem,
you solve your Problem,
you post your solution.

Hope this thread will help one of you in the future.
H.

 

[danevarez]

Hello!
I'm glad you figured out a way to solve it. I have the exact same problem. Would you please be more specific in how you solved this issue showing the "Unit_Name" instead of the ID number for it?? Thanks in advance!!