Using formula field in selection formula
Quote:
> I am trying to pass a number("rec") to a report in a formula
> field("frec"). I would like to the report to use the value of "frec" in
> the WHERE clause of the SELECT statement. Does anyone know if this can
> be done, and how?
> Regards,
> S.H.
Hi Steve,
You cannot do this. Since the formula you created is not part of the
database, it cannot be translated to SQL. Here is what you can do instead.
If you are going to be calling the report from an application, you can pass
a variable directly to the SQL with the SQLQuery property if you use the OCX
or PESetSQLQuery. This will work much better.
--
Sincerely,
Brian Dong
To reply, remove nospam from the address.
