First try and change the UniqueRecords Property of the query to true
if it doesnt work then create three seperate queries for each table

or create relation ship between the three so when you delete one table
access will delete the rest

Well, you can only delete from one table at a time.  So if you have fields from
multiple tables in the DELETE statement, the delete will normally (always?) fail.

Sample that should work:

DELECT DistinctRow TableMaster.*
FROM TableMaster INNER JOIN TableSubordinate
 ON TableMaster.RecordNumber = TableSubordinate.RecordNumber
WHERE TableSubordinate.CityName = "atlanta"

Sample that should Fail:

DELECT DistinctRow TableMaster.*, TableSubordinate.CityName
FROM TableMaster INNER JOIN TableSubordinate
 ON TableMaster.RecordNumber = TableSubordinate.RecordNumber
WHERE TableSubordinate.CityName = "atlanta"