Searching customer accounts for a specific payment method?

[pharry]

I have a payment method that I need to delete, but Actinic will not let me delete it because it is used in one or more customer accounts. How can I find these customers without going through them one at a time? I exported the customers, but the payment option is not part of the export.

Thanks.

[cdicken]

In the 'Customer' table in the 'ActinicCatalog.mdb' database is a field called 'nPaymentMethod'. This relates to the 'nID' field in the 'PaymentMethods' table.

Look up the 'nID' value you need and then scoot down the 'Customer' table to find the offending records.

[pharry]

Chris, do I need MS Access to get to that table?

[cdicken]

Ah - yes. Sorry - I was making an assumption. Can you get access (sorry) to a machine with Access?