Chat with a LIVE Microsoft Access Expert!
 
       
 

         

   

Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
 
Chat with a LIVE Microsoft Access Expert!
Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 01-19-2006, 11:54 PM
gary_getter1 gary_getter1 is offline
Registered User
 
Join Date: Jan 2006
Location: Hong Kong SAR
Posts: 17
gary_getter1 is on a distinguished road
Question Date Calculate

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.
Reply With Quote
Sponsored Links
  #2  
Old 01-20-2006, 12:14 AM
Rich
Guest
 
Posts: n/a
Look up the DateAdd function
Reply With Quote
  #3  
Old 01-20-2006, 12:14 AM
allan57's Avatar
allan57 allan57 is offline
Allan
 
Join Date: Nov 2004
Location: UK
Posts: 336
allan57 is on a distinguished road
Look at DateAdd function in help
__________________
Access 97, 2000 & 2007 on 95, 98, 2000 & XP; VB 6.0; SQL Server 2000
Reply With Quote
  #4  
Old 01-22-2006, 04:28 PM
gary_getter1 gary_getter1 is offline
Registered User
 
Join Date: Jan 2006
Location: Hong Kong SAR
Posts: 17
gary_getter1 is on a distinguished road
Thank you!!
Reply With Quote
Sponsored Links
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

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


All times are GMT -8. The time now is 04:48 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
(c) copyright 2009 Access World