Record numbers, not data, being shown in Query

[eepok]

Hello again,

A while back, I asked about the now-removed function of exporting Reports to Excel. I was told that there's no way to do so in Access 2007 and that the best best would be to export the underlying Query.

I did so and I found out that the query was showing the record number of some data pulled in via combo box (which gets data from a separate table) instead of the data itself. Logically, I can understand why that would happen, but is there a way to change that so that the intended data, not the record number, is shown?

Currently:

2008.....spring.....45.....33.....222.....bookname.....bookauthor.....edition

Preferred:

2008.....spring.....johnson.....aspen publishing.....Intro to Criminology.....bookname.....bookauthor

Once this is sorted out, I can automate the export without a problem.

 

[RuralGuy]

Join the lookup tables in your query and specify the fields you want from them.

 

[eepok]

Join the lookup tables in your query and specify the fields you want from them.

Thanks for the response. I'm going to figure out exactly what "join the lookup tables" means and I'm sure I'll come back to thank you for the solution in a bit.

 

[RuralGuy]

When you join two tables together on a Foreignkey field it is as if all of the fields in both tables were in one table. You can pick and choose the fields you want to include from either table.