Hi Liam,
That sounds like a good idea, I am going to do it. Thanks Liam.
Winn
>Hi Winn,
>
>That filter on DELETED() is probably what's causing the problem. You shouldn't use DELETED() with multi table queries. Instead, you should use SET DELETED ON.
>
>Regards,
>
>Liam
>
>>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