MS Access 2007 Data Conversion Failure in Update Query

[MindGrove]

I'm new to MS access and completely flummoxed. I've been trying to update records in a table using the following statement:

UPDATE [Specific Risk] SET [Specific Risk].[Inherent VAR]=DLookUp("[Likelihood VAR]","Likelihood","[Likelihood ID]="& [Inherent likelihood]);

I can get the equivalent Dlookup to work on a form or in a report but in this update all I get is "You are about to update 31 rows" - which is correct. This is then followed by "MS access didn't update 31 rows due to a type conversion failure". But the data types for all of the fields are type number so I can't follow the logic. Can anyone throw light on this please?

regards,

Henry

 

[PHV]

What about this ?

UPDATE [Specific Risk] INNER JOIN Likelihood ON [Specific Risk].[Inherent likelihood] = Likelihood.[Likelihood ID]
SET [Specific Risk].[Inherent VAR] = Likelihood.[Likelihood VAR]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[MindGrove]

Huge thanks,

That works a treat!

Henry