If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
addate function
I am trying to set up a dtabase of Students who must be retrained in 3 years.
At present we are having to type in the retraining date when in table mode I can't work out how to get the date retrain field to take the date in the Training date field and add 3 years automatically although I can do it in a form but this does not show up in the table Many thanks in anticipation |
#2
|
|||
|
|||
Check the online Help for the DateAdd() function.
Your problem is going to be that there's no way to execute anything from a table. The only way you can calculate the retrain date is to use a form, or by some other means, execute a query or some code. Regards, Graham R Seach Microsoft Access MVP Sydney, Australia --------------------------- "Davests" wrote in message ... I am trying to set up a dtabase of Students who must be retrained in 3 years. At present we are having to type in the retraining date when in table mode I can't work out how to get the date retrain field to take the date in the Training date field and add 3 years automatically although I can do it in a form but this does not show up in the table Many thanks in anticipation |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Stored function | CA Zuke | Running & Setting Up Queries | 1 | November 4th, 2004 12:34 PM |
continuous form | PeterM | General Discussion | 8 | October 20th, 2004 05:59 AM |
Newbe help - VBA function | Kristen | Worksheet Functions | 2 | April 21st, 2004 10:30 PM |
Customising the Function Wizard | Frank Kabel | Worksheet Functions | 1 | April 20th, 2004 06:46 PM |
Customising the Function Wizard | MikeCave | Worksheet Functions | 0 | April 19th, 2004 03:33 PM |