use the result of a query column as a header in the same query?

[mike_980]

Hi everyone,
for complex reasons I am using Access 2000 for this little project.

I have a query which basically returns a time log of engine data,

LogTime...........PID_description.......... ECU_value
07.28.46...... Engine coolant temp ............65


07.28.47 ..... Engine coolant temp ............65


Ideally I want to be able to export this data to excel, with PID_discription hidden and "Engine coolant temp" as the header for the "ECU_value" header.

The end result I have in my head is something like this:

LogTime ....Engine coolant temp
07.28.46................. 65
07.28.47 ................ 65

I also need to be able to add up to around 100 other values to the query from other PID descriptors.

At the moment I have a table with each PID ID number with its description which is linked to the table of data from the log file so that a description can be linked to the PID numbers in the log.

Hopefully it is understandable what I am after!

[June7]

What do you mean by 'add up to around 100 other values'? You want each descriptor to be a separate column? That sounds like a CROSSTAB query. In Excel it is a pivot table.

[mike_980]

Sorry i should have explained better, i will have a form which controls the query so the user can select to view engine coolant temp, then maybe engine oil temp and ignition advance. There are around 140 parameters measured in the log so in theory the user could select them all (though unlilely). Then i essentially want the PID description to be the query header with the values displayed under it so that the query will be easier to view in data format and easier to graph from in excel.

Although i have good experience in access and excel i am so far pretty ignorant of crosstabs and pivot tables so i will check them out now thanks

[June7]

Is the graphing so complicated can't do it in Access? All of my graphing is done within Access.