You can use expressions.

Query                   qryTrans = new Query();
QueryBuildDataSource    dsTrans;
;

dsTrans = qryTrans.addDataSource(tablenum(LedgerTrans));
dsTrans.addRange(fieldnum(LedgerTrans,AmountMST)).value(strFmt
('((AmountMST < 0) || (AmountMSTSecond < 0))'));

Tuorto Emiliano
[EMAIL PROTECTED]

--- In [email protected], "Hansen, Erik"
<[EMAIL PROTECTED]> wrote:
>
> Is it possible to or two fields in a query?
> I need to see records from at table if either field1 or field2 is
filled in.
>
> Best regards
> Erik Hansen
>
> WM-data e-Applications, Concorde Øst
> Lautrupvang 10
> DK-2750 Ballerup
> Phone: +45 4478 4000, Fax: +45 4478 4001
> Mobile: +45 2249 9785
> mailto:[EMAIL PROTECTED]
> http://www.wmdata.dk
>










YAHOO! GROUPS LINKS




Reply via email to