Default Value

C

CompuPal

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.
 
D

Duane Hookom

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display weeks from a Milestone 0
Countdown macro - display settings 2
MS Project. Real progress of the project, % complete 1
2016 Project, adding a workday to custom field 0
VBA - exporting serial letters to single documents 0
Publisher is filling blank lines with data 2
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Project Start and End Date is not consistent 1

Top