The first query returns the fields with the serial number and the date it was tested:
Field Value
SN 1234
TDate 2/1/02 8:18AM
Result 1.234
The second query returns about 200 records for each test date containing the individual time records with the format:
Field Value
SN 1234
TDate 2/1/02 8:18AM
RTime 0.000
Temp 300.123
Press1 1000.12
Press2 1123.45
I would like the exported format to be
Field Name R1 R2 R3 etc.
"RTime" 0.000 0.001 0.002
"1234 2-1-02 8:18 Temp" 300.123 295.120 280.001
"1234 2-1-02 8:18 Press1" 1000.12 930.12 850.95
"1234 2-1-02 8:18 Press2" 1123.45 1007.67 900.17
"2234 2-1-02 8:18 Temp" 305.123 290.120 282.001
"2234 2-1-02 8:18 Press1" 1120.45 1017.67 909.17
"2234 2-1-02 8:18 Press2" 1323.45 1107.67 990.17
"3234 2-1-02 8:18 Temp" 305.123 290.120 282.001
"3234 2-1-02 8:18 Press1" 1120.45 1017.67 909.17
"3234 2-1-02 8:18 Press2" 1323.45 1107.67 990.17
I would like to do this within the query if possible. At this point I am using generic names like "Oxy 1", "Helium 1","Oxy 2", "Helium 2". I'm sure you can see where this can get confusing if somebody's trying to do manipulations outside the application.
Thanks