DCount in Subform question

  • Thread starter Thread starter BrettS
  • Start date Start date
B

BrettS

I have a subform table on one of my forms. The fields in this subform of
importance are "Sample Count" and "# of Measurements"

The Sample Count field is an autonumber field, and I want the # of
Measurments field to be a DCount function simply counting the number of
different [Meas ID #] for the Sample Count of that row. I'm not sure how to
put this into the DCount function.

DCount("[Meas ID #]", "[Meas Data]","[Sample Count]=" & ???)

I'm not sure how to complete that to have it look at the Sample Count of
that record. Any help would be very appreciated.

Thanks,
Brett
 
After reading my intial post, just for clarity I figured I should explain the
structure of my database a little further. There are basically two tiers of
data, Sample Data and Measurement data. Basically each sample has some
number of measurements. There are two different tables, [Sample Data] and
[Meas Data]. Sample Count is just a number 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 is based on the [Sample Data] table. So I want the DCount
function to look at every record and count how many different [Meas ID #]
entries in the [Meas Data] table have that particular [Sample Count].

I hope that clears things up a bit.
 
Back
Top