Hi Sheena,

A reasonable way to do this is to create a view of your table with a new column, cstatus, and populate that field as desired.


>Hello:
>
>I have a variable as a controlsource for a column in my grid
>cstatus.
>
>This is not part of a database, only for display purposes.
>
>It's value is filled by the following case statement:
>Do Case
>
> Case (ddate <= gisum.startdate) and (nregistered < nmaxium)
> Cstatus = "Open"
>
> Case (ddate > gisum.startdate)m)
> Cstatus = "Closed"
>
> Case (nregistered > nmaxium) and (ddate <= gisum.startdate)
> Cstatus = "Overbooked"
>
>Endcase
>
>However, each record will always show the last value entered.
>So if record 3 cstatus is closed, it will display this value in record
>1 and 2.
>
>How can I get this to display properly in my grid?