B
BrettS
I have a subform table in one of my forms. The fields in this subform of
importance are "Sample Count" and "# of Measurements".
There are basically two tiers of data in the database, [Sample Data] and
[Meas Data]. Basically each sample has some number of measurements. There
are two different tables, [Sample Data] and [Meas Data]. Sample Count is
just an autonumber field identifying each individual Sample and its carried
over to the [Meas Data] table as well so every Measurement is linked to its
sample.
The subform's control source is the [Sample Data] table. So I want the
DCount function to look at every record in the [Sample Data] and count how
many different [Meas ID #] entries in the [Meas Data] table have that
particular [Sample Count]. I'm not sure how to put this into the DCount
function.
DCount("[Meas ID #]", "[Meas Data]","[Sample Count]=" & ???)
Any help would be very appreciated.
Thanks,
Brett
importance are "Sample Count" and "# of Measurements".
There are basically two tiers of data in the database, [Sample Data] and
[Meas Data]. Basically each sample has some number of measurements. There
are two different tables, [Sample Data] and [Meas Data]. Sample Count is
just an autonumber field identifying each individual Sample and its carried
over to the [Meas Data] table as well so every Measurement is linked to its
sample.
The subform's control source is the [Sample Data] table. So I want the
DCount function to look at every record in the [Sample Data] and count how
many different [Meas ID #] entries in the [Meas Data] table have that
particular [Sample Count]. I'm not sure how to put this into the DCount
function.
DCount("[Meas ID #]", "[Meas Data]","[Sample Count]=" & ???)
Any help would be very appreciated.
Thanks,
Brett