Subject | Re: [IBO] Calculated fields problem.. |
---|---|
Author | Woody (TMW) |
Post date | 2004-10-20T22:14:31Z |
>Yes, but then it wouldn't update when the fields were changed. I would have
> 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
to close and reopen the query each time for the calculation to take effect.
Woody (TMW)