Update value to null

A

Alex

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].,
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]));
 
M

Michel Walsh

Hi,


At first glance, changing INNER JOIN to LEFT JOIN would do.


Hoping it may help,
Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unmatched record query help 5
Update Query Help 1
Union Query WHERE clause 4
Update query in code syntax help 1
Help with Update query SQL 2
Setvalue expression too long 2
SetValue expression not working 1
Recordset not updateable 3

Top