Hi,

I want a simple report to display competencies held by individuals i.e "Smith" and "Car". But what I get is either "Smith" and " " (nothing) or "1" and "2". In other words I keep getting numerical values for the information I want to see.

What is the answer please anyone ?

That would be because you are using lookups at TABLE level. See here for why you should not:
The Evils of Lookup Fields in Tables (http://www.mvps.org/access/lookupfields.htm)

You need to change your report record source to be a QUERY that pulls both from training and from Competency Type, (and any other lookup table).

Cheers Bob, but how. I have been using wizards to get my forms and stuff going. Is it just a little tweak somewhere?

Metr

Try this:
http://www.btabdevelopment.com/main/QuickTutorials/A2K7Changerecordsourcefromtabletoquery/tabid/75/Default.aspx

Or this:
http://www.btabdevelopment.com/main/FullTutorials/Howtousequeriestogetyourlookupvalues/tabid/134/Default.aspx

Cheers Bob I'm gonna have to study this for a while as it might as well be in Chinese. I undesrtand about 2% of the text. Cant even see if I have to start again or just change what I have.

To be honest some of my tables seem to have developed little plus signs next to them, god knows why.

Mert

Desperate now will someone please look at my database and create a report that lists names and competencies. I just cant do it!!