Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

default value date expressions

Forum home » Delegate support and help forum » Microsoft Access Training and help » Default Value Date Expressions

Default Value Date Expressions

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

Access tip:

Insert The Current Time

To insert the current time into a Table field or Form textbox use:

Ctrl+Colon(:)

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.16 secs.