98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Default Value Date Expressions
Default Value Date Expressions
Resolved · High Priority · Version 2003
Harriet has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Default Value Date Expressions
I have a field called 'date received' a field called 'internal deadline' and one called 'extrnal deadline'
The internal deadline is always 21 days after 'date received'.
The external deadline is always 41 days after 'date received'
In my table i want both the internal and external deadline fields to be auto generated when i enter a date in the 'date received' field.
eg. 'internal deadline'= 'date received' + 21 days.
I have tried the add date function, but that will not work.
I eventually want to create a working form, so that other users can enter this data with ease.
In this sense would it be easier to create this expression in form design rather then tabkle, if so how?
RE: Default Value Date Expressions
Hi Harriet,
Thank you for your question and welcome to the forum.
If you vreate the form and add all the relevant fields and then open the control toobox.
Select the text box (ab) and draw out the text box. Edit the label to read Internal Deadline.
Right click over the Unbound control and choose properties. Go to the Data tab followed by clicking the three dots at the end of the Control Source property.
Try the following formula for the Internal Deadline and do the same for the External Deadline:
[DateReceived]+21
http://articles.techrepublic.com.com/5100-10878_11-6176441.html
I hope this answers your question.
Regards
Simon
Tue 11 May 2010: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Hide Access TablesOne method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys. |