var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: [SOLVED] Use a query to subtract two fields
I am new to access and having trouble working out how to do this.
I have two separate fields (from the same table), each with scores from 1-6.
etc. I am trying to work out an SQL query that will subtract the forst from the second:
ie Change = FollowScore - InitialScore
But my syntax is wrong. Is there a SUBTRACT function (like 'Sum') - I've tried this without success
Should it look something like??
Thanks for any help.
SELECT Subtract(Demographics.FollowGrade-Demographics.InitialGrade) AS [Change],
If they're both numeric values of the same data type...
SELECT number1 - number2 As [Change]
Thank you. Works perfectly.