Exporting Lookup Field To Excel

[HarryScofs]

Hi I am exporting a query to Excel that is based on a table and pulls criteria from a textbox in another form.

The Table on which the form is based has two fields: Company Name and Project Name. These Fields are combo boxes that pull their data from two different tables. The data in the table displays as text but is saved as an number (The fields ID value).



Is there any way that I can get the text value to export instead of the number????

[pbaldy]

Your query should join the two tables on the appropriate field(s), which lets you include fields from both tables in the result.