I have a grid which displays various fields from table EVENTS. Some of the fields within the table are numeric and I want to display a figure for each record in the table, based on the following:

Recorded Value To Be Calculated As

field1 1 0
field2 2 1
field3 3 2

Thus if a specimin record has the above recorded values in fields1,field2,field3, I would like the calculated value of 3 to be displayed in the grid column.

I guess I am asking as to how to execute a small amount of code within a grid column so as to display the result of the calculation, rather than the actual contents of a number of fields.

Any ideas?

Thank You!