I have the following Update query, which works fine.  However, if there is no
longer an inner join record in the ExcelARefParts table, how can I update the
fields in the AllNewParts table to null?  Thanks.

UPDATE AllNewParts INNER JOIN ExcelARefParts1 ON (AllNewParts.[Model#] =
ExcelARefParts1.[Model#]) AND (AllNewParts.RefPart = ExcelARefParts1.[Part#])
AND (AllNewParts.RefPartNHL = ExcelARefParts1.[AS Part#]) SET
AllNewParts.RefPartEAU = [ExcelARefParts1].[Annual Qty],
AllNewParts.RefPartStatus = [ExcelARefParts1].[S],
AllNewParts.RefPartMatlCode = [ExcelARefParts1].[Matl Code],
AllNewParts.RefPartWtlb = [ExcelARefParts1].[FIN WTLB],
AllNewParts.RefPartQty = [ExcelARefParts1].[Qty], AllNewParts.RefPartMatlCost
= [ExcelARefParts1].[Matl], AllNewParts.RefPartVarCost =
[ExcelARefParts1].[Variable], AllNewParts.RefPartNPCCost =
[ExcelARefParts1].[NPC]
WHERE (((AllNewParts.[Model#])=[forms]![Export_Ref_Parts]![ModelToImport]));