>
> hi,
>
> you could write your SQL statement as
>
> SELECT ID
> , EMPNUM
> , (FIRSTNAME || ' ' || MI || ' ' || LASTNAME) AS FULLNAME
> , FIRSTNAME
> , LASTNAME
> , MI
> , STREET1
> , STREET2
> , CITY
> , STATE
> , ZIPCODE
> , HOMEPHONE
> , HIREDATE
> , TERMINATIONDATE
> , COMMENT
> FROM EMPLOYEE
> ORDER BY 2

Yes, but then it wouldn't update when the fields were changed. I would have
to close and reopen the query each time for the calculation to take effect.

Woody (TMW)