DCount in subform syntax question

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top