Delete empty record

[Guest]

Hi,
I want to delete a record in a table that has no data.
I have tried Like "" in my query but that does not work.
Please assist.
Thanks
George

 

[MGFoster]

Hi,
I want to delete a record in a table that has no data.
I have tried Like "" in my query but that does not work.
Please assist.

Whaaa....???? That's like trying to pour water out of an empty bucket.

What, exactly, are you trying to do?

 

[Guest]

I import a table that has some rows/records with no data. I then run a
mismatch query that picks up the records with empty cells. I would like to
performa a delete query that finds the fileds with no data and delete that
record.
Thanks MG

 

[arthurjr07]

Try this

Delete From Table1 where Field1 is null

 

[Guest]

very obvious... thanks for your help