Hi everybody,
we are using since a long time excel spreadsheets for certain data input thereby creating tables of the following 4x11 datapoint structure
(Table for product1 at time1)
Dose |CD1 CD2 CD3 CD4
======|======================
DoseA |CD1A CD2A CD3A CD4A
DoseB |CD1B CD2B CD3B CD4B
: |
: |
: |
DoseK |CD1K CD2K CD3K CD4K
(Table for product2 at time1)
Dose |CD1 CD2 CD3 CD4
======|======================
DoseO |CD1O CD2O CD3O CD4O
DoseP |CD1P CD2P CD3P CD4P
: |
: |
: |
DoseZ |CD1Z CD2Z CD3Z CD4Z
(Table for product1 at time2 - note that the doses @ time1 = doses @ time2, and actually DoseB-DoseA = DoseC-DoseB, etc. The values CD1A etc. are of course different from those of time1)
Dose |CD1 CD2 CD3 CD4
======|======================
DoseA |CD1A CD2A CD3A CD4A
DoseB |CD1B CD2B CD3B CD4B
: |
: |
: |
DoseK |CD1K CD2K CD3K CD4K
Now we have approx. 1000 products at 7 different times (that means we have 7000 of such tables) with those 44 datapoints in EXCEL sheets. x/y diagrams represent the 44 datapoints for each time and each product (i.e. 7000 graphs). The equation obtained from trendline analysis is actually that what is of interest.
I wanted to include this into one Access table/form showing the type of table shown above and the x/y graph.
The user selects the product, then the time and he should just see the table and the graph for this particular condition.
My first approach: a product table related to 7 time tables with a field for each the 44 data points. The related form has a bound combobox for the products, option buttons for the different times and just 4 unbound textboxes to display the datapoints, in order to feed the diagram.
Now I am getting lost in my code, and I wonder, if there is a more simple strategy for both, table and form design.
Being basically clueless, (I am pretty new) I would appreciate any general or detailed comment. I certainly would be willing to disclose further data details, if somebody is seriously interested and has delt with similar problems.
Thanks, georgp
we are using since a long time excel spreadsheets for certain data input thereby creating tables of the following 4x11 datapoint structure
(Table for product1 at time1)
Dose |CD1 CD2 CD3 CD4
======|======================
DoseA |CD1A CD2A CD3A CD4A
DoseB |CD1B CD2B CD3B CD4B
: |
: |
: |
DoseK |CD1K CD2K CD3K CD4K
(Table for product2 at time1)
Dose |CD1 CD2 CD3 CD4
======|======================
DoseO |CD1O CD2O CD3O CD4O
DoseP |CD1P CD2P CD3P CD4P
: |
: |
: |
DoseZ |CD1Z CD2Z CD3Z CD4Z
(Table for product1 at time2 - note that the doses @ time1 = doses @ time2, and actually DoseB-DoseA = DoseC-DoseB, etc. The values CD1A etc. are of course different from those of time1)
Dose |CD1 CD2 CD3 CD4
======|======================
DoseA |CD1A CD2A CD3A CD4A
DoseB |CD1B CD2B CD3B CD4B
: |
: |
: |
DoseK |CD1K CD2K CD3K CD4K
Now we have approx. 1000 products at 7 different times (that means we have 7000 of such tables) with those 44 datapoints in EXCEL sheets. x/y diagrams represent the 44 datapoints for each time and each product (i.e. 7000 graphs). The equation obtained from trendline analysis is actually that what is of interest.
I wanted to include this into one Access table/form showing the type of table shown above and the x/y graph.
The user selects the product, then the time and he should just see the table and the graph for this particular condition.
My first approach: a product table related to 7 time tables with a field for each the 44 data points. The related form has a bound combobox for the products, option buttons for the different times and just 4 unbound textboxes to display the datapoints, in order to feed the diagram.
Now I am getting lost in my code, and I wonder, if there is a more simple strategy for both, table and form design.
Being basically clueless, (I am pretty new) I would appreciate any general or detailed comment. I certainly would be willing to disclose further data details, if somebody is seriously interested and has delt with similar problems.
Thanks, georgp
