Query returning numbers instead of Names

[BigMac4]

Hi all



I have a simple query that is set to return the last data dependant on a date, the thing is some of my fields that have names in them return with a number not the name must be a setting wrong somewhere but cant find it.


Any help apprieciated.

Mac

[RuralGuy]

Are you per chance using "LookUp" Fields? http://access.mvps.org/access/lookupfields.htm

[BigMac4]

Yes I am and it returns the number that represents the data I want so if I want bill and it's third on the list it returns 3. Can't stop it, starting to annoy Abit now.

[RuralGuy]

Anf if you followed the link you will see why they are avoided by most developers.

[BigMac4]

I'm going to have to take it out I think.

[RuralGuy]

That would be a wise decision. Having LookUps at the Form level is just fine. Having them at the table level just confuses the programmer.