help with counting records in sub form

  • Thread starter Patrick Stubbin
  • Start date
P

Patrick Stubbin

in reference to the previous item, what i want is:

to be able to count the number of records in a recordsetclone where the
field value (only one field per record) is null

??
 
J

John Vinson

what i want is:

to be able to count the number of records in a recordsetclone where the
field value (only one field per record) is null
Click to expand...

DCount("*", "tablename", "[ID] = " & Me!ID & " AND [Field] IS NULL")

using your master/child link criteria in place of my ID.

John W. Vinson[MVP]
 
Top