Query Expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Thanks for your help. It is jus what I needed to know.

Joe

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


Joe said:
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
Click to expand...
Click to expand...
 
Back
Top