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.

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.