Query.. Need help with expression

[Gigantcus]

Hello so I have done my query and all but now I just need to add last field which is "Appointment date". I want to make an expression that will add 1 year for every date so for example I have date 01/01/1999 and the expression would change it to 01/01/2000. Is this possible to make in query or do I have to make it in table? Any help is appreciated.

 

[pbaldy]

In design view:

ApptDate: DateAdd(...)

check in help for the arguments of the DateAdd() function.

 

[Gigantcus]

Thanks Pbaldy. For anyone wondering what expression I used in my query, here it is:
Annual Checkup: DateAdd("yyyy",1,[Appointment Date])

 

[pbaldy]

Happy to help!