Formula Editor: How to say "If x field is empty, then include record?"

[jselkes]

I need to filter records so that Crystal Reports will include records that meet 2 criteria:<br><br>{TWDATA.SalesmanCode} = &quot;RD&quot; and<br>{EVENT.EventCode}=&quot;RPT&quot; ---- which would typically be filled in with a date, IS EMPTY.&nbsp;&nbsp;<br><br>HOW DO YOU EXPRESS THE FILTERING CRITERION FOR THE FIELD BEING &quot;EMPTY?&quot;<br>AND HOW DO YOU EXPRESS THE FILTERING CRITERION FOR THE FIELD &quot;NOT EMPTY.&quot;<br><br>If you know how to state the correct formula (I believe in &quot;Select Expert&quot; &quot;Formula Editor&quot i'd appreciate your help.&nbsp;&nbsp;<br><br>Thank you.&nbsp;&nbsp;&nbsp;Josh Elkes<br><br><br>

 

[Guest_imported]

To include only records with an empty field use<br>isnull({table.field}) in your selection formula. To get the opposite, use not isnull({table.field}).

 

[HoustonGuy]

Remember there is a difference between... <br><br>IsNull{MyTable.MyField} and<br>{MyTable.MyField} = &quot; &quot;<br><br>You may know this already - apologies if you do. <p>Cody ford<br><a href=mailto:codyford@yahoo.com>codyford@yahoo.com</a><br><a href= > </a><br>VB, VBS, Seagate Info/Crystal Reports<br>