Null Dates

[aries]

I was wondering how I might pull up records that have no date entered into the Date field. In access 2000, "Is Null" works fine but doesn't seem to work in CR, for me, anyways.
Also, if you are trying to pull up records with more than one criteria, is there a specific order they need to be in, in the formula? [sig][/sig]

 

[fatbloke]

In CR6 the function IsNull(table.date_field) works fine.

To function correctly the 'IsNull' clause must be the first in your formula (or within a bracketed sub-formula). Reference their website (

http://www.seagatesoftware.com)

for information on ordering your conditions; one document in their knowledge base is c2000247.

I had similar problems recently, but getting the syntax into the correct order fixed them. [sig][/sig]

 

[aries]

Thanks For the info and the link. That will help me immensly.!! [sig][/sig]