Custom function as criteria ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi !
I have a table with 1 fields containing numbers( type double) . Some fields
can contain home made constant like 999999999 representing that the data is
confidential, 888888888 representing that the data is not available etc...

I'd like to run a query that could sum that field without the value of those
constant.
and ideally replace those constant by alpha sign like "X" or "-" just in the
query !

Can this be done ?
Thank's
 
The constants are not available in the context of the query.

But since the query is calling your custom function, it could replace the
argument passed in with the constant.
 
Back
Top