Hi Sandi.
>I'm using the Query.getfilter to allow the users to enter a filter for reports. I have a few fields that need to be specially formatted in order to return a match. For example my customer # field is C(10) and if my clients are using auto numbering the number is stored as ' 1' or ' 889898'. My index is IIF(VAL(custno)=0,custno,PADL(STR(VAL(custno),10),10))
>
>How/where would I change the filter being built from upper(custno) to my IIF statement so it can find a match in my tables?
You can change the cFieldExpr property of the field object in the fields collection. That expression is used for the filter. Normally it contains just the field name, but you can change it to any valid expression.
Doug
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement