OR

[patweb]

StrWhere = StrWhere + "((([T-LOOKUP-PAG].[" & CodeValue1 & "]) = YES)) or"

StrWhere is a string that will be used for an SQL. The string will contain one or more Where Conditions. However the last OR is to much.

I should count the lenght of the string and then probably use the left function to get a StrWhere without the last or.
How to do this or a better id ?

pat

 

[PHV]

Inside your loop:
StrWhere = StrWhere & " OR ([T-LOOKUP-PAG].[" & CodeValue1 & "] = YES)"
When all is done:
StrWhere = Mid(StrWhere, 4) ' get rid of 1rst OR

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[HarleyQuinn]

Try:

strWhere = Left(strWhere,Len(strWhere)-3)

Hope this helps

Harleyquinn

---------------------------------
For tsunami relief donations

 

[HarleyQuinn]

Oops, Sorry PHV. Didn't see you post when I was typing mine.

Harleyquinn

---------------------------------
For tsunami relief donations