Solved: Delete query: delete row if field is empty!

[hunsnowboard]

Hi Everyone! I go real real mad with this problem. I am very very new to access but I hoped that I can cope with this problem...well I can't.

My problem is very simple I have a table (2masolat) withmany fields.
The important field is called "Mezo1" and this field has numeric data type. This field also has some empty records. I would like to delete these rows, but I just can't. I made a delete query which looks like this:



DELETE [2masolat].Mező1, [2masolat].Mező2, [2masolat].Mező3, [2masolat].Mező4, [2masolat].Mező5, [2masolat].Mező6, [2masolat].Mező7, [2masolat].Mező8, [2masolat].Mező9, [2masolat].Mező10, [2masolat].Mező11, [2masolat].Mező12, [2masolat].Mező13, [2masolat].Mező14, [2masolat].Mező15, [2masolat].Mező16
FROM 2masolat
WHERE ((([2masolat].Mező1)=IsNumeric()));


I tried with IsEmpty and IsNull as well but I get an error that argument is missing? How can I delete in acces a row if one field's data is empty???
Thank you in advance for your help, and have a nice weekend!

[hunsnowboard]

Hi Everyone! Ok...finally I found the solution!
Here is the working code:


DELETE [2masolat].Mező1, [2masolat].Mező2, [2masolat].Mező3, [2masolat].Mező4, [2masolat].Mező5, [2masolat].Mező6, [2masolat].Mező7, [2masolat].Mező8, [2masolat].Mező9, [2masolat].Mező10, [2masolat].Mező11, [2masolat].Mező12, [2masolat].Mező13, [2masolat].Mező14, [2masolat].Mező15, [2masolat].Mező16, IsNumeric([2masolat]![Mező1])
FROM 2masolat
WHERE (((IsNumeric([2masolat]![Mező1]))=False));