Fixing calculated value.

[djchapple]

I have read many times that one should not fix a calculated value but to me it is essential that the value is fixed.

My problem is twofold.

1. I am a complete ignoramus when it comes to everything access and I have no idea how best to construct a database.

2. My own database is very simple. It will has two tables

1. A table holding all the personal data on the volunteers at a nature reserve

2. A rota comprising all the days from day one to who knows when. Against each day will be the names of the volunteers manning the centre in the morning and in the afternoon. There are usually two volunteers on duty.

From this database I wish to print off a Report which is basically a calendar onto which the volunteers will place their names for future duty over the next 3 months.

Every week I update my database on my computer using the Form I printed off earlier (with all its hand written amendments) and once a month or so I print off a new Report.

Using the second table I have a query to create a date using the DateAdd function with the interval equal to a day the [ID] as the number of intervals. Once calculated I do not want this date ever to change. How I can I fix it?

Your help would be appreciated with this problem and any advice on how to improve the database.

I am using Windows 7 and Access 2007 on one computer and Access 2010 on another so it must be compatible with Access 2007 and 2010

 

[PNGBill]

If you have a table of Volunteers and a Table of Shifts and in the Shifts table you enter a Name from the Volunteers table then this should be all you need to do.
Why would any of this change?

A Database should have data added and edited/deleted by use of Forms and here is where you can restrict the access.

Have a form to enter the data and set the properties to allow Data Entry but not Edit.
You can have a button to allow edit, in the case of error, but this has to be clicked to allow an edit. You could attach a password to this - I think.