Subform showing query result and a running calculation

[Colin Clark]

Hello,

I have a database of scores for a sports club. I want to display a continuous subform showing a person's scores for the season along with a running calculation based on those scores (the handicap), i.e. 3 fields per line in the subform showing date, score, handicap. The handicap needs to be calculated in VBA code as it is fairly complex to work out and depends on previous scores as well as the current score.

I can get a query to extract the relevant scores and display them in the subform, but I have no idea how to display the running handicap calculation next to each score. I thought I could do something like append a handicap field to the subform's Recordset, then loop through each record and set the handicap field to a calculated value based on the running handicap and the current score, but it doesn't seem to be possible to add a field to the Recordset.

I'm using Access 2000.

I'd be grateful for any suggestions!

Thanks,
Colin.

[Rabbit]

Hello,

I have a database of scores for a sports club. I want to display a continuous subform showing a person's scores for the season along with a running calculation based on those scores (the handicap), i.e. 3 fields per line in the subform showing date, score, handicap. The handicap needs to be calculated in VBA code as it is fairly complex to work out and depends on previous scores as well as the current score.

I can get a query to extract the relevant scores and display them in the subform, but I have no idea how to display the running handicap calculation next to each score. I thought I could do something like append a handicap field to the subform's Recordset, then loop through each record and set the handicap field to a calculated value based on the running handicap and the current score, but it doesn't seem to be possible to add a field to the Recordset.

I'm using Access 2000.

I'd be grateful for any suggestions!

Thanks,
Colin.

Create a dummy field in the table that's included with the recordset.