Look for blank date fields

**NOTLguy** · 10-16-2010, 06:36 AM

I wish to query a table for blank date fields. Is that possible? The Field is named DeathDate, and would be blank if the persion was not deceased.

Any help would be appreciated,

Thanks,
Bill

**slave138** · 10-16-2010, 07:48 AM

Create your query and set the criteria for DeathDate to

Code:

"" Or Is Null

**NOTLguy** · 10-17-2010, 07:37 AM

Originally Posted by slave138

Create your query and set the criteria for DeathDate to

Code:

"" Or Is Null

Thank you, it worked fine.

Regards,
Bill

**slave138** · 10-17-2010, 07:56 AM

My pleasure. Enjoy the rest of the weekend.

Look for blank date fields

Thread Tools

Look for blank date fields

Similar Threads

Setting Blank Fields to "N/A"

Populate Date field (CurrentDate + 30) in table if blank

Default Date in Date Fields

one date entered to hit 3 fields in one table how?

Date Calculation within same fields

Posting Permissions