Calculating Dates (2 Viewers)

[Raak]

I am trying to create a form where a user inputs data into a Table. What i would like to find out is how can i add 7 days to the date they enter in a field. Does this require VBA Coding or is this a task that can be done in Access without code.

TIA,
Raakesh

 

[Talismanic]

If your field name is [date] just make another field that says =[date]+7. It does not require a macro but you could make it into one.

[This message has been edited by Talismanic (edited 05-25-2000).]

 

[Raak]

Do i do this in the Query Area or in another area? What i was looking to do is when the user enters a date in one field i wanted to add 5 working days to Due Date field automatically so that the User does not have to think..

TIA,
Raak

 

[Talismanic]

If the user is entering the data in a form you could add a field (bound or unbound) to the form that would display the revised date.

If you need the field that they enter the data in to auto change you could make a macro similar to this one:

Action SetValue
Item [Forms]![dateform]![Datefield]
Expression [datefield]+7

Then set the trigger when the date is added or updated.

[This message has been edited by Talismanic (edited 05-26-2000).]

 

[Raak]

Thanks a bunch...i will try it out and let everyone know how it worked out.

Raak