Default Value in Table

[Cora]

I need a default value in my table to be the date value of another field in
the table + 25 days. When I try to place this in the default value box, it
says there is a type mismatch.

="ANLDate" + 25

Both fields are short date format.

Any help is greatly appreciated.

 

[Gina Whipp]

Cora,

What you are trying to do cannot be done at the table level. You will need
to do that on the form level. Is there any particular reason you are doing
this in a table?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I need a default value in my table to be the date value of another field in
the table + 25 days. When I try to place this in the default value box, it
says there is a type mismatch.

="ANLDate" + 25

Both fields are short date format.

Any help is greatly appreciated.

 

[KARL DEWEY]

When you use ="ANLDate" + 25 you are trying to add a number to a text string
and that don't work. It would be =[ANLDate] + 25 but that will not work as
the default is used when a new record is created and [ANLDate] is null upon
creation of a new record.

There is no reason to store the calculation as you can always do it in a
query or report.