Library database

[LDP]

I am building a library database ane need some help with some coding.



I have ? fields: Issue date, Renewal1, Renewal2 and Date due.

The date due is automatically set to 21 days time from the issue date. However, if the book is renewed, I want the date due field to automatically update to 21 days time for the renewal date.

How would I do this?

[orange]

Before getting too far into coding, I recommend you get a good model for your "database".

Here are a few links that will help you with design.

http://forums.aspfree.com/attachment...achmentid=4712 General Database principles

http://www.rogersaccesslibrary.com/T...lationship.zip
http://www.rogersaccesslibrary.com/f..._Databases.zip

For general guidance/info on Access and Database - there is an online book at
http://www.accessmvp.com/strive4peace/ Look at chapter 3 for Normalization and names

For your specific questions, investigate the DateAdd function.