emorris1000
Registered User.
- Local time
- Today, 10:38
- Joined
- Feb 22, 2011
- Messages
- 125
I have 2 tables, TRundata and TGCData linked many <-> through a 3rd table (TGenDat) by field PolyID
TRundata records the flow of Gas A, data logged every 0.3 seconds or so. 2 Fields of interest, Time and Flow
TGCdata records the concentration of Gas A, data logged every 5 minutes. 2 Fields of interest, Time and Concentration
I want to be able to look at these two values together plotted over time. My guess is to use a Union query and just put these two tables together. This will give me a table with a lot of blank values, which I don't like, but I can't think of any other way to do it. This is what it would look like:
T F C
x y _
x y _
x y _
x y _
x _ z
x y _
x y _
x y _
x y _
x _ z
x y _
x y _
x y _
Is this the proper way to do this? My ultimate goal is to be able to graph these together.
Edit: Had some difficulty getting the example table to show.
TRundata records the flow of Gas A, data logged every 0.3 seconds or so. 2 Fields of interest, Time and Flow
TGCdata records the concentration of Gas A, data logged every 5 minutes. 2 Fields of interest, Time and Concentration
I want to be able to look at these two values together plotted over time. My guess is to use a Union query and just put these two tables together. This will give me a table with a lot of blank values, which I don't like, but I can't think of any other way to do it. This is what it would look like:
T F C
x y _
x y _
x y _
x y _
x _ z
x y _
x y _
x y _
x y _
x _ z
x y _
x y _
x y _
Is this the proper way to do this? My ultimate goal is to be able to graph these together.
Edit: Had some difficulty getting the example table to show.
Last edited: