on my form i am try to build a part that adds two other parts together but it
is adding the wrong parts. i have a life expectancy of product section, and
i want this to add to a section i have that has date item was put in to use
and the resulting field is needed replace date. the problem is that the life
expectancy is adding the days not the years. this is what i have for the
expression builder but it is adding the days like 5/5/2005 + 7 = 5/12/2005
when i want 5/5/20012 as an answer
=[Date Item was put in to use]+[Life Expectency of Unit (in Years)]

The + will add as days, use DateAdd function instead

=DateAdd("yyyy",[Life Expectency of Unit (in Years)],[Date Item was put in
to use])

"yyyy" - specify that you want to add it as years

--
Good Luck
BS"D


"Need Access Help" wrote:

> on my form i am try to build a part that adds two other parts together but it
> is adding the wrong parts. i have a life expectancy of product section, and
> i want this to add to a section i have that has date item was put in to use
> and the resulting field is needed replace date. the problem is that the life
> expectancy is adding the days not the years. this is what i have for the
> expression builder but it is adding the days like 5/5/2005 + 7 = 5/12/2005
> when i want 5/5/20012 as an answer
> =[Date Item was put in to use]+[Life Expectency of Unit (in Years)]

Use DateAdd(), e.g.:

DateAdd("yyyy", [Life Expectency of Unit (in Years)], [Date Item was put
in to use])

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Need Access Help" <(E-Mail Removed)> wrote in
message
news:83FDA2B7-B1F5-495C-938D-(E-Mail Removed)...
> on my form i am try to build a part that adds two other parts together but
> it
> is adding the wrong parts. i have a life expectancy of product section,
> and
> i want this to add to a section i have that has date item was put in to
> use
> and the resulting field is needed replace date. the problem is that the
> life
> expectancy is adding the days not the years. this is what i have for the
> expression builder but it is adding the days like 5/5/2005 + 7 = 5/12/2005
> when i want 5/5/20012 as an answer
> =[Date Item was put in to use]+[Life Expectency of Unit (in Years)]