Returning year as a number

[NeilT123]

I have a query as follows

SELECT tblSoilAnalysisResults.FieldCode, tblSoilAnalysisResults.AnalysisNumber, tblSoilAnalysisResults.UseResinNutBal, tblSoilAnalysisResults.DateOfAnalysis, Year([DateOfAnalysis]) AS [Year]
FROM tblSoilAnalysisResults
WHERE (((tblSoilAnalysisResults.UseResinNutBal)=Yes));

and I need the "Year" to be a number so that I can do simple sums on it so for example when the answer is 2005 and I add 1 it gives 2006. I can get Year to look like a number but not act like a number. Can anyone help please?

 

[JBinQLD]

Hey Neil,

Cint function can prolly help buddy, look it up. Also consider the dateadd function. Both have ample info in the help file.

Hope this helps mate,

JB