Calculating dates and number of days

[SegaBraves]

Hi,
I'm doing a small database for my friend's family business and trying to figure out a way how I can calculate: the date, the number of days, giving us the end date.

For example;

Date:
10/1/2008


# Of Days Left on Membership:
30

Ending Date:
10/31/2008

Does anyone know what type of calculation I can use in Access 2007 to create this automatic generated "ending date"?

Thanks guys!

 

[Skotor]

I'm no expert, but try using the Dateadd function...

Dateadd ("d",30,[date field])

 

[SegaBraves]

Thank you!

 

[Markg]

Hi I am trying to do the same thing for a DVD rental system that I am making for a friend.

I have set up all folders and forms. I dont know where to put any code to do any calculations.

I am trying to have it so that when I enter todays date in a new record in the rental table that it asks for a msgbox to enter the number of days on loan...and then calculate and save the date in the date due field.

When a dvd is being returned i want to be able to automatically work out the late fee using the daily late rate, and the difference between the dates in days...

I havent used access in a few years and have become terribly rusty.

Thanks in advance for your help

Thanks for your help

Mark

 

[Rabbie]

Hi I am trying to do the same thing for a DVD rental system that I am making for a friend.

I have set up all folders and forms. I dont know where to put any code to do any calculations.

I am trying to have it so that when I enter todays date in a new record in the rental table that it asks for a msgbox to enter the number of days on loan...and then calculate and save the date in the date due field.

When a dvd is being returned i want to be able to automatically work out the late fee using the daily late rate, and the difference between the dates in days...

I havent used access in a few years and have become terribly rusty.

Thanks in advance for your help

Thanks for your help

Mark

In this post you say you are building building a DVD rental DB as course work. Now you say it is for a friend. Please be honest with us if you want help

 

[Markg]

Rabbie,

You assumed that it was my coursework in the other post when I never said it was. It is indeed course work, and for a friend, I cant see how these are mutually exclusive.

"Hi All,

I am currently trying to make a db for a DVD rental company. (Coursework)"

I came here to try and get some help as I am helping my FRIEND with her COURSEWORK.

I have been consistent and honest in both posts and would appreciate your help, however if you can't help me or are just being vindictive, I hope you appreciate the fact that your post and in fact your view was unhelpful and erroneous.

 

[Rabbie]

Thanks for clearing that up. Why not try

DateDue = Date() + NoDaysLoan