Default Value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a default value, DateDiff() expression on my table from
an Start Date field and and End Date field. How do I go about doing this
successfully. I have tried: DateDiff("d", [Start Date], [End Date]) I keep
getting a message that 'Start Date" is not recognized in the definition.
Please help!

Thank you.
 
You can't do this in a table definition. You also probably shouldn't. You
could add some code to a form to set a value of a field/text box.
 
Back
Top