K
Kens4554
I work with an instrument that creates time stamped status records that
contain information about its various operating parameters every second. At
the end of extended test periods (1,000,000 seconds say) I want to find out,
for instance, what the temperature change of the processor was while a
certain operation was being performed. I know when each occurance of the
event starts and when it ends by a value in a timer field. I want to know
how to subtract the start temp from the end temp of the event. I do not know
how to reference the fields in prior records within a query.
For my modest skills, this is normally an Excel task, but the files are so
big and there are junk lines in the file that cause relative references to
screw up the calculations. (it starts as fixed width text with headers, and
contains error lines and other 'junk' information I can easily ask an Access
query to ignore). I can import and clean up the file with Access, then
export to Excel (if I upgrade to 2007, since 2003 does not support enough
rows), but what a pain.
contain information about its various operating parameters every second. At
the end of extended test periods (1,000,000 seconds say) I want to find out,
for instance, what the temperature change of the processor was while a
certain operation was being performed. I know when each occurance of the
event starts and when it ends by a value in a timer field. I want to know
how to subtract the start temp from the end temp of the event. I do not know
how to reference the fields in prior records within a query.
For my modest skills, this is normally an Excel task, but the files are so
big and there are junk lines in the file that cause relative references to
screw up the calculations. (it starts as fixed width text with headers, and
contains error lines and other 'junk' information I can easily ask an Access
query to ignore). I can import and clean up the file with Access, then
export to Excel (if I upgrade to 2007, since 2003 does not support enough
rows), but what a pain.