vba filter expression syntax

[Prattdakota]

Hello - I'm having an issue with a filter to a recordset in my code. When I try to ensure the correct precedence by adding parenthesis I get an error. For example:

The following line works fine:

 .Filter = "TransPostFiscalYear = " & intFiscalYear & " AND (TransactionCode = 'ASST SURGEON') OR (TransactionCode = 'ATTENDNOTP')"

However, the following line of code, which is the same except for two parenthesis being removed, produces an error stating "Arguements are of the wrong type, are out of acceptable range, or are in conflict with one another"

 .Filter = "TransPostFiscalYear = " & intFiscalYear & " AND (TransactionCode = 'ASST SURGEON' OR TransactionCode = 'ATTENDNOTP')"

Seems odd to me that just forcing the precedence should have this effect. I'm out of ideas. If you have an idea for me to try I'd appreciate your insight.

Thanks

 

[PHV]

What about this ?

.Filter = "TransPostFiscalYear=" & intFiscalYear & " AND TransactionCode In ('ASST SURGEON','ATTENDNOTP')"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Prattdakota]

Hi PH. Thanks very much for the suggestion. That was a good idea and I hadn't thought of it. Unfortunately it didn't seem to do the trick either. I also tried the following with the same resultant error message:

 .Filter = "TransactionCode In ('ASST SURGEON', 'ATTENDNOTP')"

I appreciate the suggestion.

 

[SeeThru]

I think when it builds it itself, you may need to add the FiscalYear more than once...

.Filter = ("TransPostFiscalYear = " & intFiscalYear & " AND TransactionCode = 'ASST SURGEON') OR ("TransPostFiscalYear = " & intFiscalYear & " AND TransactionCode = 'ATTENDNOTP')"

SeeThru
Synergy Connections Ltd - Telemarketing Services

http://www.synergyconnections.co.uk

 

[Prattdakota]

Thanks for the reply SeeThru. Yes, I've resorted to just that type of coding which does seem to work. I actually have about a dozen transaction codes but just used two to illustrate the problem. I guess this is just one case where I'll make it work but never understand the cause of the error.

Thanks again,