I have a fild that on my report that contains a company number. Is there any way I can modify this field to look up the company name that is associated with this company number, so that it will display the company name instead of the company number? Hope this make sense.

Thanks!

You can either use DLookup or the prefered method and add the company name into your underlying query.
HTH

Thanks! I'll look into it.