Exporting Query Results, Foreign Key Values and Column Headers

[RyanP]

Am exporting a query result to excel, but the table being queried only stores the foreign key values. So the query references the lookup table in order to export the display value. All is well.


However the Column Header is then the Column Header/ Caption of the lookup table

I use the lookup table for many data tables so I cannot change its field name / caption as it wouldn't be appropriate in all cases. (lookup table is Employees; the Caption is 'Full Name').

The fields that use the lookup have various names, i.e. 'Created By' 'Reported By' 'Closed By' etc which are the captions on the data tables.

Just using the DoCmd.OutputTo acOutputQuery function...

What to do?!?

[June7]

Try an alias name in the query.

Post the SQL statement of your query.

[RyanP]

"Try an alias name in the query" I'm a NEWB enough to have never done that...

In a nutshell;

"SELECT lstEmployees.[Full Name] FROM lstEmployees INNER JOIN tblReports ON lstEmployees.ID = tblReports.ReportedBy;"

[June7]

SELECT lstEmployees.[Full Name] AS ReportedBy FROM lstEmployees INNER JOIN tblReports ON lstEmployees.ID = tblReports.ReportedBy;

That query doesn't show any fields selected from tblReports. Should it?

[RyanP]

SELECT * AS "Alias". Well, that was easy Bit less of a newb now I figure...

As for the simplified query, it was only for example purposes. that particular query would only return the one field from tblReports...

thanks!