I am attempting to add a specified amount of time (months elapsed) to an already existing value. However when the code executes, it returns values as if it is ignoring the "specified" amount of time which I have bolded below.
Any ideas?
Any ideas?
Code:
sql3 = sql3 & ", " & Month(DateAdd("m", I - 1, Me.Add_Dt_First_Subject_Enrolled) + [B](Me.Add_Study_Months_Elapsed)[/B]) & ","