Link to home
Start Free TrialLog in
Avatar of PeterBaileyUk
PeterBaileyUk

asked on

delete query in access

I have this query:

SELECT TVIData.wb_deriv
FROM TVIData
WHERE (((TVIData.wb_deriv) Like "* *"));

Open in new window


I would like to have a query to delete those rows but not sure how am in access 2016.
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jyothees venkat
jyothees venkat

DELETE
      FROM
TVIData
      WHERE (((TVIData.wb_deriv) Like "* *"));

Open in new window

So, you are looking to delete every record where the [wb_deriv] contains a space, anywhere within the field?  If that's the case then Rgonzo's response should work.

But just to make sure, I'd make a copy of that table before you do it;  those deletions cannot be undone.
Avatar of PeterBaileyUk

ASKER

Yes where that field has for example"anytext space anytext"
thank you