remove null records from a query ?

[Hapr1]

Hi, I have a query which works perfectly and deletes the unnecessary records according to the criteria i have set , but i dunt want this null values in all column to display in the exported output file. how do i delete the records which are already null .
i tried delete query but it did not work . This is in microsoft Access.

Please help me

 

[ScottGem]

Hi, I have a query which works perfectly and deletes the unnecessary records according to the criteria i have set , but i dunt want this null values in all column to display in the exported output file. how do i delete the records which are already null .
i tried delete query but it did not work . This is in microsoft Access.

Please help me

What defines a null? Records are not null. Every record should have a Primary key so i can't have all null fields. Only fields are null. So you need to define what field being null should be deleted.

 

[Hapr1]

got the answer !

Hello , I solved the proble m ,
i had to use ' '( single quotes ) in criteria fields to remove all empty fields in a table .
Thanks

 

[ScottGem]

Hello , I solved the proble m ,
i had to use ' '( single quotes ) in criteria fields to remove all empty fields in a table .
Thanks

Ok, remember a null and a blank field are different.