VBA FOR Data Freezing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have to print out & save monthly salary in MS ACCESSreports for the future
reference, my problem when I change my data in the employee profile like
salary, the change appear in all the month’ reports, so I want help in any
VBA code to use in access to freeze or generate the current mont h Data
report without any change in future if any change occurred in employee
profile.
Thanks
 
On Tue, 6 Nov 2007 03:46:00 -0800, Alam

That's because of a database design error. The most common example is
one with Orders > OrderDetails > Products (with Price field).
If you change a price, would an old order print with different amount?

Not if you save the price AT THAT TIME in the OrderDetails (or
sometimes: InvoiceDetails) table.

-Tom.
 
Your problem is a design issue. You should have a table that records the
actually salary paid on each pay day for each employee and your report should
be based on this table.
 
Back
Top