| Chat with a LIVE Microsoft
Access Expert! |
||||
|
||||
|
#1
|
|||
|
|||
|
I want to calculate a data from anthony table, like (20 Jan 2005) + 365 days
will be 20 Jan 2006, how can i do it. The Table setting is just like below: Constituent (DataID,...); Student (DataID, DOB,...); School (DataID, 4YearsOld(As a Date Format),...) Anyone can help me, Thank you. ![]() |
| Sponsored Links |
|
#2
|
|||
|
|||
|
Look up the DateAdd function
|
|
#3
|
||||
|
||||
|
Look at DateAdd function in help
__________________
Access 97, 2000 & 2007 on 95, 98, 2000 & XP; VB 6.0; SQL Server 2000 |
|
#4
|
|||
|
|||
|
Thank you!!
|
| Sponsored Links |
![]() |
| Thread Tools | |
| Display Modes | Rate This Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Use a textbox date value to calculate another date | chrisdedobb | Forms | 3 | 11-05-2004 09:30 AM |
| How to calculate a date in a form | scottappleford | Forms | 3 | 04-15-2003 04:49 AM |
| Date Calculation on Form -- Please Help | joe789 | Forms | 4 | 04-26-2001 11:00 AM |
| Custom Date Function Nightmare!! | Louise | Modules & VBA | 2 | 08-16-2000 02:53 PM |
| Date Function Help Needed Please!! | Rgomez1999 | Modules & VBA | 0 | 04-12-2000 03:42 PM |