Search results

  1. E

    Linking 2 tables through a query involving a time

    Clearly I am missing something. I totally get it if you are done here, but here we go. What you're saying makes perfect sense if I was using Excel. I would select the ranges for each {Time,Response} series and plot them. But I don't see how you can plot 2 discreet series with 2 discreet...
  2. E

    Linking 2 tables through a query involving a time

    First, thank you very much for your patience. I can sometimes be a bit of a brick wall when people are explaining stuff to me. But I promise I am trying to understand. I'll go back through your previous comments to see if I undestood them. -------- ---Many to many comment. I've always had...
  3. E

    Linking 2 tables through a query involving a time

    My brain feels like melted cheese, so that's good. I should be a bit clearer on the primary/foreign keys etc. [PolyID] is a unique identifier for an experiment [PolyID] is the Primary Key for TGeneralData. TGeneralData has one record per experiement, and records 1 dimensional details about...
  4. E

    Linking 2 tables through a query involving a time

    Thanks for the reply. Yeah its many to many. The problem I have with a simple join query is that I get two fields for time (1 from each table) instead of 1. What I want is for the time field to merge from 2 fields into 1. Like shuffling cards. It will retain the flow/concentration values from...
  5. E

    Linking 2 tables through a query involving a time

    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...
Back
Top Bottom