Incorrect Syntax for SUM

I have the following query below, written in access, I need to convert it to sql

SELECT dbo_job.jobid, Sum([workitem.quantity]*[templateprice.price]) AS [value]

I have as follows

SUM(dbo.workitem.quantity * dbo.templateprice.price) AS [Value]

However I am getting different values than the access statement

Is there an error in the syntax

Thanks

Poly