Gene,
In case you ever need a query like we discussed again. The following will
work.

The query below will sets the Bills.LetterStatus to C ( Canceled ) for each
account that has a Letters.Letter=2 ordered

UPDATE Bills SET Bills.LetterStatus = 'C'
WHERE
Bills.Bill in (SELECT Letters.Bill FROM Letters WHERE Letters.Letter = 2)


--
Thanks,
Phil Chapman
Fax (413) 556-5674