Want 2 column headings when exporting to excel. 1

[Petemush]

Hey,

I am currently have a crosstab query which shows training courses down the side and employee's surnames as column headings. The value in the cells is the status: "Completed", "Needed", "Booked On". If an employee is not related to a certain course, then a blank cell is shown.

I know Access limits crosstab queries to one column heading but I think excel allows two. Since some employees have the same surname, it would be helpful if I could show their forename as a column heading as well.

Is there anyway I can export this data to excel and make an extra column heading?

Gathering the data is easy enough as a temporary table stores all the employee id's of the employees included in the crosstab query.

So, any ideas?

Cheers!

Pete

 

[lhite]

In the source query for your crosstab query just create a new field:

FullName:[FirstName] &" " & [LastName]

Use the newly-created FullName field in the crosstab rather than the LastName.

-Larry

 

[Petemush]

Genius! Works a treat.

Thanks a lot,

Pete