Calculate Due Date

[Guest]

This is probably an easy question, but I can't seem to figure it out. I have
a date claim received field. I need to calculate the date report due which
is 34 days past the date claim received. I tried creating an unbound field
with the control source equal to [date claim received]+34, but all I get is
#Name? in the field. The field is on a form that is bound to a table with
all the information.
Any ideas?

 

[Brendan Reynolds]

Do you have an "=" in front of the field name?

=[date claim received] + 34

 

[Guest]

You betch ya.

Do you have an "=" in front of the field name?

=[date claim received] + 34

--
Brendan Reynolds

This is probably an easy question, but I can't seem to figure it out. I
have
a date claim received field. I need to calculate the date report due
which
is 34 days past the date claim received. I tried creating an unbound
field
with the control source equal to [date claim received]+34, but all I get
is
#Name? in the field. The field is on a form that is bound to a table with
all the information.
Any ideas?

 

[Brendan Reynolds]

Is the control perhaps also named "date claim received"? If so, try changing
the name of the control.

--
Brendan Reynolds

You betch ya.

Do you have an "=" in front of the field name?

=[date claim received] + 34

--
Brendan Reynolds

This is probably an easy question, but I can't seem to figure it out.
I
have
a date claim received field. I need to calculate the date report due
which
is 34 days past the date claim received. I tried creating an unbound
field
with the control source equal to [date claim received]+34, but all I
get
is
#Name? in the field. The field is on a form that is bound to a table
with
all the information.
Any ideas?

 

[Bob M via AccessMonster.com]

Check your spelling. That is usually what #Name means. Add a bound object
to [date claim received] then add the = and +34.

This is probably an easy question, but I can't seem to figure it out. I have
a date claim received field. I need to calculate the date report due which
is 34 days past the date claim received. I tried creating an unbound field
with the control source equal to [date claim received]+34, but all I get is
#Name? in the field. The field is on a form that is bound to a table with
all the information.
Any ideas?

 

[fredg]

This is probably an easy question, but I can't seem to figure it out. I have
a date claim received field. I need to calculate the date report due which
is 34 days past the date claim received. I tried creating an unbound field
with the control source equal to [date claim received]+34, but all I get is
#Name? in the field. The field is on a form that is bound to a table with
all the information.
Any ideas?

1) Make sure the name of this control is NOT "date claim received".
2) Make sure you have spelled the field name correctly.
3) Is [date claimed received] field a Date datatype field?
4) Did you start the control source expression with an = sign,
i.e. =[date claim received]+34 ?
5 Does =DateAdd("d",34,[date claim received]) work?