display word not pk in report

[Teebird]

I have created my report based on a query but how do I display the word and not the PK value in my report.

eg Year table 1 = 2005, 2 = 2006 etc.

In my query it is displayed as 2005 etc but in my report it is displaying the 1 or the 2 not the year 2005 etc.

Many thanks
tee.

 

[gemma-the-husky]

why not store the actual year eg 2005 or 2006 in your table rather than the offset value. Much easier

 

[Teebird]

Many thanks for your reply. My table and query were both displaying the text value (eg 2005). What I have done is creatred a lookup table for the Year value - I was trying not to use lookup tables but I can not get this to work any other way.

I have another problem that you and someone may be able to help with.

Now in my report I am getting duplicate entries.
I have attached screen shots of my relationships, SQL for the query and my report.
Many thanks
Tee