>>check the m.lcFilter condition,
>>it certainly depends on the content of the VisCodes or Client_Hospitals records;
>>otherwise you have found a serious bug.
>
>I found I was working with the wrong database <g> Sorry.
lol
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.