Updating a row with DSum

hornsVIEW

New member
Local time
Today, 16:36
Joined
Jun 21, 2011
Messages
1
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?
 

Users who are viewing this thread

Back
Top Bottom