Delete Query

[pwoodj]

I need a little help with a Delete Query.

I want to delete all of the records with no value, I created the query, selected the Field and enter Null as my criteria. The problem is that it deletes all of the records, not just the empty ones.

any help would be great..

thanks
pete

 

[KenHigg]

You used 'Is Null' as a parameter?

Ken

 

[pwoodj]

worked like a champ...

thanks

 

[KenHigg]

.
.
.
.
.