remove null records from a query ?

Status
Not open for further replies.

Hapr1

Registered User.
Local time
Today, 06:32
Joined
Aug 4, 2005
Messages
24
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 delte the records which are already null .
i tried delete query but it did not work

Please help me
 
Typically I select a column that always has a value and use "IS NOT NULL" in the criteria on that column to select none null rows.
 
Status
Not open for further replies.

Users who are viewing this thread

Back
Top Bottom