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.
>>So, first you had too many records, now too little of them. Well, that indicates that there is one more problem with your code. Can you do the query without the WHERE line? Does it give the records that you want in your result?
>>
>>>Putting that statement in the where line, gets me no results found. There should be 5 records coming back.
>>>
>>>Thanks anyway.
>>>
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.