calculation in a query

[elmartinez]

I am using Access 2002. I am building a query and have 4 fields, 2 from a table and 2 calculated: Course (text); Years (calculation); Complete (date); NT (calculation). Years looks at Course and says
Iif(course=XYZ,2,1). What I need it to calculate NT based on adding the number from the Year field to the Complete field. In other words, if my Complete field is 1/1/2009, and my Years field is 2, I want the results in the NT field to be 1/1/2011. Is this possible and how do I do this?

[pbaldy]

Check out the DateAdd function.

[elmartinez]

Yep, you're right! Thank you!

NT: DateAdd("yyyy",[Years],[Complete])

[pbaldy]

Excellent, glad it worked for you!