PeterBaileyUk
asked on
delete query in access
I have this query:
I would like to have a query to delete those rows but not sure how am in access 2016.
SELECT TVIData.wb_deriv
FROM TVIData
WHERE (((TVIData.wb_deriv) Like "* *"));
I would like to have a query to delete those rows but not sure how am in access 2016.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
But just to make sure, I'd make a copy of that table before you do it; those deletions cannot be undone.
ASKER
Yes where that field has for example"anytext space anytext"
ASKER
thank you
Open in new window