On Sun, 27 Feb 2005 20:16:14 -0600, "DebbieG" <de*****@NOSPAM.NOSPAM>

wrote:

Your requirements are virtually identical to those of a client of

ours. You're not working for a large snackfood manufacturer, right?

Essentially, every time the app starts (or whenever you're about to

review points or print reports) it needs to loop over all employees

and determine if a new record should be added (e.g. it's been 1 year

since the last infraction - add a record that reduces points by 1/3).

The final score can indeed be calculated by a textbox in the footer of

a form or report. The controlsource would be:

=Sum(Points)

In our case it was calculated differently, because infractions would

expire after several years. The DSum function could be used.

Regards,

-Tom.

I have no idea how to start with this one.

I have a subform where records could look similar to:

Infraction Date Points

01/01/2000 3

06/01/2002 1

Somehow, I've got to calculate the points the driver has as of the current

date. For instance, in the above example:

On 01/01/2000 three points added to the driver's record.

On 01/01/2001 the points were reduced by 1/3 (2).

On 01/01/2002 the remaining points were reduced by 1/2 (1).

On 06/01/2002 one point is added to the remainder (2).

On 06/01/2003 the remaining points were reduced by 1/3 (1.33).

On 06/01/2004 the remaining points were reduced by 1/2 (0.65).

On 06/01/2005 the remaining points will be 0 if no more infractions.

I'm thinking of putting an unbound textbox in the footer of the subform that

will show the remaining points but have no idea how to do this calculation.

Can someone point me the right direction.

I'll probably have to create a report with the same calculation.

TIA,

Debbie