showing blank fields in query

[Emma]

Hi I have a table with a followup date column, I've put this in a query with
the hopes of only openning those records that have a blank followup date. I
tried =IsNull([Follow Up Date]) but this didn't bring up anything any ideas?
Thanks Emma

 

[Golfinray]

Iif([yourfield]is null,"yes","no")

 

[John W. Vinson]

Hi I have a table with a followup date column, I've put this in a query with
the hopes of only openning those records that have a blank followup date. I
tried =IsNull([Follow Up Date]) but this didn't bring up anything any ideas?
Thanks Emma

Simply use a criterion of

IS NULL

no quotes, no parentheses, on the Criteria line under the field.

IsNull() is a VBA function which returns a Boolean True or False value - and
the criterion you used will never return any records, because a Date/Time
field might be NULL or might be a Date, but won't be either True or False.

 

[Emma]

Works like a charm thanks

Hi I have a table with a followup date column, I've put this in a query with
the hopes of only openning those records that have a blank followup date. I
tried =IsNull([Follow Up Date]) but this didn't bring up anything any ideas?
Thanks Emma

Simply use a criterion of

IS NULL

no quotes, no parentheses, on the Criteria line under the field.

IsNull() is a VBA function which returns a Boolean True or False value - and
the criterion you used will never return any records, because a Date/Time
field might be NULL or might be a Date, but won't be either True or False.

 

[Emma]

Sorry now I want to do the opposite do I type NOT(IS NULL) ?

Hi I have a table with a followup date column, I've put this in a query with
the hopes of only openning those records that have a blank followup date. I
tried =IsNull([Follow Up Date]) but this didn't bring up anything any ideas?
Thanks Emma

Simply use a criterion of

IS NULL

no quotes, no parentheses, on the Criteria line under the field.

IsNull() is a VBA function which returns a Boolean True or False value - and
the criterion you used will never return any records, because a Date/Time
field might be NULL or might be a Date, but won't be either True or False.

 

[Emma]

I used IS NOT NULL and it works fine

Hi I have a table with a followup date column, I've put this in a query with
the hopes of only openning those records that have a blank followup date. I
tried =IsNull([Follow Up Date]) but this didn't bring up anything any ideas?
Thanks Emma

Simply use a criterion of

IS NULL

no quotes, no parentheses, on the Criteria line under the field.

IsNull() is a VBA function which returns a Boolean True or False value - and
the criterion you used will never return any records, because a Date/Time
field might be NULL or might be a Date, but won't be either True or False.

 

[John W. Vinson]

Sorry now I want to do the opposite do I type NOT(IS NULL) ?

That will work (did you try it? <g>); you can also use

IS NOT NULL