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?.
>
Winn Pauley