Hi Barbara,
I didn't forget it because I never used it with parentheses. Why would I need it ? I want to learn if I'm missing something. OTOH if he was doing it without PEM sheet then he need to surround with quotes.
Cetin
>One thing that Cetin forgot to mention--if you're doing this through the property sheet, you need to surround the expression with parentheses.
>----------------------------------------------------------
>>OK. Thanks. Guess I didn't fill in the right properties.
>>Much faster than a list box.
>>
>>>>Is there a way to make a calculated column in a grid like in Browse?
>>>>
>>>>For example
>>>>BROWSE FIELDS NAME = Customer.LastName + Customer.FirstName, etc...
>>>>
>>>>You can do that in a list box by setting the RowSource to the expression or a function.
>>>>But there is no Rowsource in a grid and the grid record source
>>>>allows only the alias/table name.
>>>
>>>
Just like the same. Insert a column and set its "controlsource" to your expression.
>>>Cetin