Query Expression

[Joe]

I have a database table with among other column names: DateRecd, DatePaid,
DateClosed. How do I write an expression to show only record with no date in
the "DatePaid" column

 

[Klatuu]

WHERE [DatePaid] IS NULL

 

[Joe]

Thanks for your help. It is jus what I needed to know.

Joe

WHERE [DatePaid] IS NULL
--
Dave Hargis, Microsoft Access MVP

I have a database table with among other column names: DateRecd, DatePaid,
DateClosed. How do I write an expression to show only record with no date in
the "DatePaid" column