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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

detecting unwanted characters 7
Access Access Query Criterion 1
parse some text from an inconsistent text field 6
Trying to query off of a table field name 3
Compare current month totals with last months totals 1
Find and Replace Criteria 3
Criteria for select query. 2
Help with a "like" query between two fields from two different tables... 2

Back
Top