I was following the example given by the view builder with three tables....it showed the joins and conditions seperately. Makes much sense the way both of you put it.....and, more importantly, it works the way you have it! <g>
Thanks to you both for your quick responses.
Steve Howie, owner
DaSH Technology
Denver, CO