Help with creating a filter for Notes field - test/value to use to check for presence of content

[anewton_lists]

Hello,

I would like to create a filter that checks the Notes field and
determines if there is any kind of content in the field. Haven't been
able to figure out what Test and Value pair to enter. Anyone know how
to do this?

 

[Jan De Messemaeker]

Hi,
Iif(Len([Notes])=0;truepart;falsepart)
HTH

 

[anewton_lists]

Hello Jan,

Thanks for the response. Can you tell me a bit more? Specifically, can
you guide me through the GUI? In the filter creation dialog, what
Field/ Test/Value pairing to use?

Operand | Field Name | Test | Value

 

[Jan De Messemaeker]

Sorry! I gave the answer fo ra formula and not a filter!
(Reading diagonally can seriously harm one's credibility)
Still, I now tried several things and I the use of a formula is the only way
I can find.
So it's a two-step exercice.
First, through Tools, Customize, Fields, customize a number field (f.i.
Number1)
with the formula:
Len([Notes])
Then make a filter for

Number1 does not equal 0

That does it.

Sorry for the misunderstanding.

 

[anewton_lists]

Jan, my apologies for being so delinquent in thanking you. This worked
quite well for what I needed. Thanks for the help.

 

[anewton_lists]

Oh, and I forgot to mention an added benefit if you show Number1. . .
It'll display the total number of characters (including blank spaces)
within Notes. This is handy b/c of the 255-character limit for
exporting contents of the Notes field.