Change one item...
> Where Paymethod = "Credit Card" and CreditCardAutoBill = 0
> Update MasterAccounts
> Set Paymethod = "Invoice"
> Where Paymethod = "Credit Card" and CreditCardAutoBill = 1
> and Exists (Select InvoivceID From Invoices
> Where MasterAccounts.CustomerID =
> Invoices.CustomerID
> and Type = "Credit Card")
For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html