>This is my first time using this forum so forgive me for not "quoting" your reply to me. Your solution does not work at runtime. I have tried it and I don't get the correct results. As for the UDF in the controlsource as replied to me by Edward, I've yet to try it but will give it a shot also.
>I think this problem has something to do with the table which will be the controlsource for the grid being bound into the dataenvironment as well as the grid at design time.
>
Michael, actually Nick and me spoke about the same thing, i.e. if you have simple calcualtion algorithm then you put it directly into Column.Controlsource (as Nick said), if it's too big to be put as one statement, then you use custom method. Remember, that you should Column.ControlSorce confirm in code (Grid.Init event and any time you change Grid.Recordsource).
Edward Pikman
Independent Consultant