>Let's try for the simpliest answer first: have you checked that there are
>really at least one record in Workpo that have Code = "1"?
Yes, in fact, thats ALL there is :)
I hope you not looking at something "for sure" thing. I play by "If there are some existing, accept 'em, if not, forget it" rather "hardcode" something to pull "at least" something... otherwise, excuse me, tell me what is wrong...
Today is tomorrow's yesterday.