add number of months to date

[Guest]

Hi
I have a cycle count number field and would like to add this value to a date
of manufacture field to calculate expiry date
eg if cyclecount is 24 and manufacture date is 01/08/2005 i would like field
expiry date to equal aug 2007
I have been trying various formulas but can't get correct
thanks for any help
Tina

 

[Guest]

[Expiry Date] = DateAdd("m",[CycleCount],[Manufacture Field])

 

[Guest]

Thanks Dennis
I tried that about 2 hours ago but forgot the "" around the m
Hope to have a better day tomorrow
Thanks again
Tina

[Expiry Date] = DateAdd("m",[CycleCount],[Manufacture Field])

Hi
I have a cycle count number field and would like to add this value to a date
of manufacture field to calculate expiry date
eg if cyclecount is 24 and manufacture date is 01/08/2005 i would like field
expiry date to equal aug 2007
I have been trying various formulas but can't get correct
thanks for any help
Tina

 

[Guest]

This is definitely what I am after, but being new to all this (other than the
very basics, this is my first database).

[Expiry Date]=DateAdd("m",[Months to Expiry],[Issue Date]) is the exact code
I am using. But where to I enter this code?

Thanks in advance

Thanks Dennis
I tried that about 2 hours ago but forgot the "" around the m
Hope to have a better day tomorrow
Thanks again
Tina

[Expiry Date] = DateAdd("m",[CycleCount],[Manufacture Field])

Hi
I have a cycle count number field and would like to add this value to a date
of manufacture field to calculate expiry date
eg if cyclecount is 24 and manufacture date is 01/08/2005 i would like field
expiry date to equal aug 2007
I have been trying various formulas but can't get correct
thanks for any help
Tina