Glad to hear you found a solution.

>Jorge,
>I have found that by having the tables involved opened did the trick. You were right, I should have debugged it more throughly.
>Thanks,
>Winn Pauley
>
>>Have you tried debugging it?, step through it, and check the resulting where expression. What about the lcMajor, variable?, when is a value assigned to it?, have you checked that it has the expected value before executing the query?.
>>