S
staylor74_
Hello,
I have eight tables in an Access personal database in Office 2K3. Each
table has ~150,000 records that cover a similar time period; the data are
records of environmental variables taken every fifteen minutes.
There is one field for date (Date/Time) and one field for time
(Date/Time). Due to error in the recording devices and device maintenance,
there are times when each device was off (one table for each device) and thus
the temporal ranges of the data are different for the different tables.
I need somehow to perform a function that returns only the records that
are concurrent in all eight tables, a sort of intersection of the data, so
that the tables are exactly concurrent with one another temporally.
Any idea how I could go about this?
Thanks,
S Taylor
NCSU
I have eight tables in an Access personal database in Office 2K3. Each
table has ~150,000 records that cover a similar time period; the data are
records of environmental variables taken every fifteen minutes.
There is one field for date (Date/Time) and one field for time
(Date/Time). Due to error in the recording devices and device maintenance,
there are times when each device was off (one table for each device) and thus
the temporal ranges of the data are different for the different tables.
I need somehow to perform a function that returns only the records that
are concurrent in all eight tables, a sort of intersection of the data, so
that the tables are exactly concurrent with one another temporally.
Any idea how I could go about this?
Thanks,
S Taylor
NCSU