blob-field empty or not? 1

[JeroenBoon]

Hello,

is there a way to check wether blobfields in a database are filled or empty with a "1" and "0" or something like that? Ofcourse I can print the blob, but I want to count the records with and without a blob.

Jeroen.

 

[synapsevampire]

Try a null check against it using a Running Total, or create a formula based on isnull().

You probably won't be able to select the field from the list as it's a Blob, but you can manually type in a formula akin to:

if isnull({Table.BlobField}) then
0
else
1

Then you can place this in the details and right click and perform summaries on it.

Running Totals would use a Count and in the Evaluate->Use a Formula:

isnull({Table.BlobField})

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[JeroenBoon]

Synapsevampire!!

You're the best! The problem was that the blob couldn't be selected but I never realised that it could be manually typed!
Thnx!

Jeroen.