The current field doesn't work that way in PO, unfortunately.

That subselect looks like it would work, but I'm concerned about the speed of it. I'll play around with it and see how it does.

Thanks,

Michelle

>You may want to try using where clause like
>WHERE a_pomast.purno is not in (SELECT purno, potype, purdate, currid, postat, puramt, recamt, vendno, company, "H" AS chfile) - normally SBT has a field that with current mark(X) to let you know that the record is have been moved to history.
>
>Carl