> > 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. (firstname.lastname@example.org)
For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html