I had a full question prepared showing my non-working delete query prepared, but I think it will be simpler to just show a working select query I have that selects the records I want to delete instead.
My working Select query:
Code:
SELECT [Order Details].[Product ID], [Order Details].[Order ID], Products.[Product ID], Products.[Product Name], Products.[Units In Stock]FROM [Order Details] RIGHT JOIN Products ON [Order Details].[Product ID] = Products.[Product ID]
WHERE ((([Order Details].[Order ID]) Is Null) AND ((Products.[Product ID]) Like "VD-*") AND ((Products.[Units In Stock])=0))
WITH OWNERACCESS OPTION;
What I can't seem to do is convert the above SELECT to the delete sequence of: Delete, From, Where
I simply want the new delete query to delete the records found in the Products query only, using the above criteria.
Any advice greatly appreciated.