Delete empty rows

[Igor G.]

How to delete entire row if Field2 (second column) IsNull (or empty)?
I want to create a query that deletes all rows where is in second column
empty cell.
Thanks!

 

[Alex Dybenko]

Hi,
here SQL:
Delete * from MyTable Where Field2 is null

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Daniel Pineault]

Try something like

DELETE TableName.Field2
FROM TableName
WHERE (((TableName.Field2) Is Null));

--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.