Guest_imported
New member
- Jan 1, 1970
- 0
What is the easiest way to count the number of records in a table where a specific field is empty?
TIA!
TIA!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Count records
- Thread starter Guest_imported
- Start date
- Status
Tia,
One way is as follows:
NullRecordCount = DCount("*", "tblYourTable", "IsNull(YourField)"
Replace tblYourTable with your table name, and YourField with your field name, but retain the quotes. Note that this is working on Null field values, which is what I think you're intending.
Hope that this helps,
Steve
One way is as follows:
NullRecordCount = DCount("*", "tblYourTable", "IsNull(YourField)"
Replace tblYourTable with your table name, and YourField with your field name, but retain the quotes. Note that this is working on Null field values, which is what I think you're intending.
Hope that this helps,
Steve
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question