Not Null

  • Thread starter Thread starter Kathy Green
  • Start date Start date
K

Kathy Green

I have a query and would like it to NOT show any records
where the procedure field is blank.
I have tried Not Null in the criteria space in design
view and am unsure how to write the SQL to enable me to
do this.

I am grateful for your help
Kathy
 
I have a query and would like it to NOT show any records
where the procedure field is blank.
I have tried Not Null in the criteria space in design
view and am unsure how to write the SQL to enable me to
do this.

I am grateful for your help
Kathy
Click to expand...

SELECT <whatever>
FROM <whereever>
WHERE [Procedure] IS NOT NULL
 
Back
Top