|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
January 25th, 2004, 01:08 PM
|
|||
|
|||
|
Formula within Access
Hi, i wonder if someone can help me. I am currently making a set of membership cards for a business task. The expiery date of the membership card which is shown on the card must be 6 months ahead of the issued date (also shown on the card). There must be some way that i could insert a formula in which it will automaitcally put the expiery date in when i type in the issue date? Can any one help me...if you need more info please get back to me.
Danbwest
|
|
#2
January 25th, 2004, 03:28 PM
|
||||
|
||||
|
Use DateAdd function.
Example: DateAdd("m", 6, #1/25/2004#) 'will return 7/25/2004 Check DateAdd topic in Help for more information.
__________________
BRegs, TBÁrpi "I can only show you the door. You're the one who has to walk through it."
|
|
#3
January 26th, 2004, 10:20 AM
|
|||
|
|||
|
TBArpi, thanks a lot for the info that you have given me at the top, but please could you tell me where i would place this? would it be within a query?
Thanks a lot danbwest
|
|
| Viewing: ASP Free Forums > Database > Microsoft Access Help > Formula within Access |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
