Ubrugte leverandør i min tabel

Leverandør tabellen er linket til en ordering tabel "purchase order".

Jeg skal ha slette alle de leverandører hvor 'purchaceID number' er false

Hi Jan
Make a query and name it qryDelete

SELECT Suppliers.SupplierID
FROM Suppliers LEFT JOIN [Purchase Orders] ON Suppliers.SupplierID = [Purchase Orders].SupplierID
WHERE ((([Purchase Orders].SupplierID) Is Null));

Then make another query
DELETE Suppliers.*
FROM Suppliers WHERE SupplierID IN (SELECT SupplierID FROM qryDelete )

the first query finds the suppliers which have no purchases

Make a backup of you rdB first, justin case it doesnt work :o)

Hi Terry, I will try

'terry' hvem der bare kunne trylle som dig :-) Tak for hjælpen igen....

selv tak, og god weekend Jan

Forgot to say, I canty sail ships, only them in my bath tub :o)