Why numbers

[hotmert]

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 ?

 

[boblarson]

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

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).

 

[hotmert]

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

Metr

 

[boblarson]

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

 

[boblarson]

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

 

[hotmert]

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

 

[hotmert]

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