Is dcount the right way to go???

[equaliser]

I hope this is the right forum to put this in?

I have a main table that hold all the details of a batch ie. batch number etc. This is linked to another table by batch number that lists the parts by serial no. in a batch. It also lists with each serial a yes/no field that shows if the is rejected or not.

PROBLEM:

In the main table i have a field that I want to count the number of parts that have been rejected (yes in the Field) for that batch. I've tried Dcount to no avail. Is this the right way to go.

I seem to be using u epople a lot recently thanks for your patiance

EQ

 

[edtab]

Try this:

Dcount("[FieldName]","tableName","[FieldName] = -1")

Substitute your own field and table names accordingly.