Selecting rows

[prr]

Hi
I have an Access table that has 80 000 rows and now I have to delete all the rows that have only one word in it (that have no spaces). I have no idea how to do it. Please help!

Thank you in advance
Prr

 

[Rabbie]

Try writing a Delete Query to do this for you.

To do this first use the Query Design Grid to create a Select Query to pick up the records with no spaces then change the Query Type to delete. When you open that query it will delete the records for you.

 

[allan57]

DELETE *
FROM YourTableNameHere
WHERE YourTableNameHere.FieldNameToApplyCriteriaTo Not Like "* *";

However I would advise you to backup your table first, just in case you accidently delete all data ie if you missed the space between the two asterisks all records will be deleted..