Fixed Fees

[Haytham]

Hi All...
I have a table with many fields for Staff Details.
It picks an amount to be paid according to their age..
e.g. For Employee, 300. For wives and children 300 etc.. Id Card fees is 50 if required, tax 2 etc..
These figures are stored in a tblFees. In a query I did a calculation which results in the amount of fees to be paid for the renewal of Passport.
The problem is that:
If this constant fees change, it affects all the records even those since long time..
My point is how to let any changes in tblFees to alter the new records only and not the saved once....
Thank you

 

[Rich]

Store the relevant fee at the time the passport was issued.

 

[Haytham]

Hi,
Do I have to create a new table to maintain a history record which will not get altered when any figures get modified...
Or Should I create append query to append data to a new table !!

 

[Haytham]

Any idea please

 

[Haytham]

Hi Pat,
I have 2 tables, one for StaffDetails and the other for FeesDetails. Do I have to create a new table which stores the calculated fees according to a specific criteria, or I can store it in my StaffDetails table.
I run the calculation in a query.
My main problem is:
If I store calculated fees in a table and then change the fees in FeesDetails table.. then whenever I open my record it undergoes a new modification. i.e. I have to create a new form to open my saved data without passing th' my entry form which is based from a calculated query..
Does that make sense..
Else, if there is any sample db I can refer I'll be very greatful to you..
Many thanks.

 

[Haytham]

Thanks a lot.