Good morning,
Is it possible to set the default value for a field which is the result of an expression? For example, suppose I have two date fields Date1 and Date2. I want Date 2 to equal Date1 plus 3 months. In table design view, I tried this by entering the following as the default value for Date2: [date1] + 90. Access tells me it doesn't recognize the variable Date1.
Lee
Is it possible to set the default value for a field which is the result of an expression? For example, suppose I have two date fields Date1 and Date2. I want Date 2 to equal Date1 plus 3 months. In table design view, I tried this by entering the following as the default value for Date2: [date1] + 90. Access tells me it doesn't recognize the variable Date1.
Lee