Hello everyone. I a trying to update a table via aggregate sum with parameters however the parameters seem to be ignored.
Code:#
PARAMETERS [@project_id] Text ( 255 ), [@comment] Text ( 255 ); UPDATE DimensionsTotal INNER JOIN Dimensions ON DimensionsTotal.[DimComment]=Dimensions.Comment SET DimensionsTotal.Subtotal = DSum(("[Timsing]*[Dimension]"),"[Dimensions]", ((Dimensions.ProjectID)=[@project_id]) And ((Dimensions.Comment)=[@comment])) WHERE ((Dimensions.ProjectID)=[@project_id]) And ((Dimensions.Comment)=[@comment]);
#
Can somebody please help?
Code:#
PARAMETERS [@project_id] Text ( 255 ), [@comment] Text ( 255 ); UPDATE DimensionsTotal INNER JOIN Dimensions ON DimensionsTotal.[DimComment]=Dimensions.Comment SET DimensionsTotal.Subtotal = DSum(("[Timsing]*[Dimension]"),"[Dimensions]", ((Dimensions.ProjectID)=[@project_id]) And ((Dimensions.Comment)=[@comment])) WHERE ((Dimensions.ProjectID)=[@project_id]) And ((Dimensions.Comment)=[@comment]);
#
Can somebody please help?