> > FYI...
> >
> > 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")
>
> Isn't that the second time I've done that? I must need sleep....
>
> --
> Dale E. Reed Jr. (daler@iea-software.com)
For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html