YEAH!!!
>Okay, you get a star too. ;-)
>It was a combination of everyone saying that the one line should work in a where and me trying to do a quick fix, that I spotted the real problem and fixed it.
>
>Have a great weekend.
>>For ONE time I was quicker than Sergey. Nevertheless you gave him a point and none to me. It just isn't fair. You spoiled my day. <g>
>>
>>>Found it. The .NULL. in that field were causing the problem. Converted them to "" and It works now.
>>>
>>>Thanks for the Help.
Groet,
Peter de Valença
Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.