Automated Dates In Table

[SPower]

Hi i'm kinda new to access and I have been teaching myself through youtube videos to set up a database for customers.

I have set up a table of customers who are paying for a subscription, for example they will either pay monthly, quarterly or in full AND for periods of 1, 2 or 3 years.

I have a column/field called "start date" another called "renewal date" and one more called "subscription length" (1 2 or 3 years) but everytime I have a new customer I have to manually type both in. (The subscription length is a set value so I've used a drop down lookup wizard box).
I would like to know a way where the "renewal date" is automatically calculated by using the "start date" field and "subscription length" field.

Thanks!

 

[speakers_86]

Do not use the lookup wizard. Use a combo box on your form.

Before you go any further, look into database normalization.

 

[SPower]

ok thanks, just had a quick look and i cant find how to use a combo box?

 

[speakers_86]

Google is your friend. I hate to blow you off, but you will have to do much research to make a db. Mine took me six months.

Also, the combo box wizard is extremely easy to use.

 

[SPower]

alrite well i've just added a combo box to a form but have no idea how to relate it to the rest of my database - what would i need to google to find my answer?

 

[MSAccessRookie]

alrite well i've just added a combo box to a form but have no idea how to relate it to the rest of my database - what would i need to google to find my answer?

Try this tutorial that I found using a Google Search for "Combo Box Tutorial". If you do not like or understand this one, the search provides many other options.


http://fisher.osu.edu/~muhanna_1/837/MSAccess/tutorials/combo.pdf

 

[WIS]

I would like to know a way where the "renewal date" is automatically calculated by using the "start date" field and "subscription length" field.
Thanks!

Dates in Access are stored as numbers - the no of days from 12/31/1899 where this date is 0 (or 1). If you have a "start date" field and you add the "subscription length" as days (eg 1 yr = 365, 2 yrs = 730 etc) this will give you the "renewal date" (you'll be 1 day short across a leap year).

 

[Rich]

You can calculate the renewal date either in a query or an unbound textbox by using the DateAdd function