Records System and Dates !

[Parariddle]

Hi

I am trying to create a record log in Access 2000 for all our regular reporting.

I have created the input side no problem but I am have an issue over calculating due dates. The reports can range from daily to Annually with different frequencys inbetween. I appreciate I will have a start date for all reports its how I then calculate the due dates for the different frequencys and how I can have that appear in the dataset so when the user next opens the input form the new due date is shown !

An Example would be

Report 1 is Monthly and started on 01/01/2008. Once a user enters information on completing the report I would like Access to generate a new due date which would be 02/02/2008 and so on and son. I hope this makes sense !

Thanks in Advance !

 

[Rabbie]

See the DateAdd function. This should let you calculate the due dates.

 

[Parariddle]

Thank You Rabbie I will give that a go and see what happens !

Thanks !