MS Access and Date Calculations
Posted by admin on 25 Sep 2008 at 10:28 PM
$5.00
I have a membership database, loosely based on the example provided with Access. What I need to do is be able to enter a payment for dues, and from that payment, calculate the member expiration date. I have a payment form that allows me to enter the purpose of the payment, but I am not stuck trying to get the expiration date correct. Any assistance or direction you could offer would be greatly appreciated.
Thank you in advance for your help.
Thank you in advance for your help.
Accepted Answer:
| Answer provided by admin on 25 Sep 2008 at 10:28 PM Well that depends on the formula. What you would do is use the After Update event of the payment amount control and insert code there to set the expiration date. The code would calculate the date and then assign it to the control on the form. |
| Rating: * * * * * Awarded: $5.00 |
Ask a Question
Most Recent Questions
Most Recent Answers
Home Page
Login
Register
Information Technology
Programming Languages
Database
- Microsoft Access
- MySQL
- Oracle
- PostGreSQL
- SQL Server
- Visual FoxPro
Graphic Design
Operating Platforms
Hardware and Networking
Math and Science
Biology and Geology
Math and Statistics
Chemistry
Physics
Engineering

Are you an information
Most Recent Questions
Most Recent Answers
Home Page
Login
Register
Information Technology
Software, Hardware, Design
Programming LanguagesDatabase
- Microsoft Access
- MySQL
- Oracle
- PostGreSQL
- SQL Server
- Visual FoxPro
Graphic Design
Operating Platforms
Hardware and Networking
Math and Science
Homework Help
Biology and GeologyMath and Statistics
Chemistry
Physics
Engineering
Are you an information
technology or
math/science expert?
You can earn money by
providing answers to questions
at AnswerArchive.com.
Learn How