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
polynominalAsked:
Who is Participating?
 
XPIMatthiasCommented:
Hi,

syntax is ok,

effect stems from different data formats (column types) and their calculation logic. Check if the column types have the same precision on access and on sql.

Matthias
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.