You can put expression you want in the ControlSource of the calculated column. Something like

(field1-1)+(field2-1)+(filed3-1)

>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!