Null Values Problem

[MattyJacks]

Is there anyway to count the number of records down a specific field in a form which contain a null value. If anyone knows any functions which may help it would be very appreciated.

 

[John Big Booty]

You can use the IsNull() to test for fields that contain Null values. Be aware that this will not identify fields that contain zero length strings ("").

If you wish to count Null values in a query you can use the criteria Is Null in a Totals Query and select the Count option.

 

[MattyJacks]

This doesn't really help me as i am quite new to Access. Also i need this to be added to an unbound box on a form, not in a query.

 

[John Big Booty]

Try the DCount() function then.