Null Values Problem (1 Viewer)

M

MattyJacks

Registered User.

Local time

Today, 10:55

Joined

Mar 15, 2011

Messages

14

• Mar 15, 2011

• #1

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

AWF VIP

Local time

Tomorrow, 03:55

Joined

Aug 29, 2005

Messages

8,263

• Mar 15, 2011

• #2

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.

 

M

MattyJacks

Registered User.

Local time

Today, 10:55

Joined

Mar 15, 2011

Messages

14

• Mar 16, 2011

• #3

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

AWF VIP

Local time

Tomorrow, 03:55

Joined

Aug 29, 2005

Messages

8,263

• Mar 16, 2011

• #4

Try the DCount() function then.