|
02-22-2010, 11:33 AM
| |||
| |||
 Default Value in Table
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.  |
|
02-22-2010, 11:54 AM
| |||
| |||
| RE: Default Value in Table
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. |
|
02-22-2010, 02:53 PM
| |||
| |||
| Re: Default Value in Table
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? source: microsoft > public > access |
 |
| Thread Tools | |
| Display Modes | |
| |
Linear Mode
