P
park.walter
Hello all-
I use Access more for it's data handling capabilities than it's
database capabilities so here goes.
In one table I have specimen information that can be characterized
into ~30 different study groups. Each specimen can be in one or more
study groups. I also have a data table that has ~60,000 records for
each specimen. I would like to analyze data from the samples in each
group and examine it across other members of the same group. Here's a
simple design:
SpecTbl columns:
Spec
Group
Time
etc.
DataTbl columns:
Spec1
Spec2
etc
I would like to capture the data for the Specs in each group so that I
can manipulate the data. However, currently I have to manually select
the Specs to add to each group. Is there a way to do this
automatically since I've already recorded the information in the
SpecTbl ? Part of my problem has been the lack of Access GB capacity
- Tables that contain 60,000 records and are 200+ Spec wide are quite
difficult to work with.
Can anyone offer a suggestion to alleviate the bottleneck?
wdp
ps. I am not a programmer and do not work with SQL....
I use Access more for it's data handling capabilities than it's
database capabilities so here goes.
In one table I have specimen information that can be characterized
into ~30 different study groups. Each specimen can be in one or more
study groups. I also have a data table that has ~60,000 records for
each specimen. I would like to analyze data from the samples in each
group and examine it across other members of the same group. Here's a
simple design:
SpecTbl columns:
Spec
Group
Time
etc.
DataTbl columns:
Spec1
Spec2
etc
I would like to capture the data for the Specs in each group so that I
can manipulate the data. However, currently I have to manually select
the Specs to add to each group. Is there a way to do this
automatically since I've already recorded the information in the
SpecTbl ? Part of my problem has been the lack of Access GB capacity
- Tables that contain 60,000 records and are 200+ Spec wide are quite
difficult to work with.
Can anyone offer a suggestion to alleviate the bottleneck?
wdp
ps. I am not a programmer and do not work with SQL....