So Simple I'm Embarassed to Ask!

[Richie2837]

I'm trying to write a very simple query which will return everyone in my contacts database who does not have a date in the "case closed" field (NB everyone who is "live" as a contact). What do I need to put in the criteria of the query to return only the live contacts?

 

[GaryPanic]

"case closed" is null
should do it

 

[Michael J Ross]

Hi,

How about Is Null as your criteria under Case Closed?

 

[Richie2837]

Both work - I new it would be embarassingly simple! Thanks

 

[GaryPanic]

I would recommend getting some access books

Access bible pretty good heavy reading but worth it