D
Duncan Edment
I have a database that contains Start / End times for
several employees. As part of the operation of the
database, it displays a weekly + / - and a cumulative + / -
time figure.
The Weekly +/- figure is calculated as:
Number of hours worked in week - 37
The Cumulative +/- figure is calculated as:
(Sum of all hours worked since 01/01/03) - (37 * Num full
weeks since 01/01/03)
As are getting closer to the end of the year, there are a
large number of entries and so, a larger number of
calculations are being performed. This results in
flicker, and general slow-down of the database.
My question to you all is, is it possible to simplify /
improve my calculations, so as to reduce flicker and speed-
up operation?
If required, I can post contents of the calculation
fields, if this will help.
Thanks & Regards
Duncan
several employees. As part of the operation of the
database, it displays a weekly + / - and a cumulative + / -
time figure.
The Weekly +/- figure is calculated as:
Number of hours worked in week - 37
The Cumulative +/- figure is calculated as:
(Sum of all hours worked since 01/01/03) - (37 * Num full
weeks since 01/01/03)
As are getting closer to the end of the year, there are a
large number of entries and so, a larger number of
calculations are being performed. This results in
flicker, and general slow-down of the database.
My question to you all is, is it possible to simplify /
improve my calculations, so as to reduce flicker and speed-
up operation?
If required, I can post contents of the calculation
fields, if this will help.
Thanks & Regards
Duncan