---------------------------------------------------------------------------
LL>Peter,
LL>PR> Say I want a QBE field to contain
LL>PR> either the contents of table field A or table field B depending on the
LL>PR> contents of table field C.  In Access I could write
LL>PR> IIF(FieldC="Something",FieldA, FieldB).
LL>What you want is a CHANGETO query, probably more than one.  Consider the
LL>following:
LL>   TABLE | FieldA | FieldB | FieldC                     |
LL>         | _A     |        | Something, CHANGETO _A     |
LL>         |        | _B     | not Something, CHANGETO _B |
Thanks a lot -- I think I can make this work.  Glad to see you're still
monitoring this echo.  Maybe Version 6 will let us embed functions in a
query!
Still getting a lot of use out of Inside Paradox 5 for Windows. . .
Peter
peter.reader@nwcs.org
 * SLMR 2.1a * All hope abandon, ye who enter messages here.
--- WILDMAIL!/WC v4.12 
---------------