Fieldname not recognised - crosstab query error

[vbaInet]

Using a Dlookup is absolutely out of the question!

At least it was an option

So you're left with Taruz's saving into a table or building using fixed Column Headings. Mind you, you can fix the column headings by building your SQL in code.

 

[scubadiver007]

I need to use an outer join to get all the PMS and GMS contract practices combined with the crosstab query for export to an Excel spreadsheet. So I can order the fixed columns how I need them.

Thanks for the help.

 

[vbaInet]

* Get the distinct values from the recordset
* Use the IN operator in the PIVOT line and build it so it looks like:

PIVOT [FieldName] IN ('Header 1', 'Header 2', 'Header 3')

... etc