[Emerald] monthly totals

Josh Hillman ( (no email) )
Fri, 16 Jun 2000 11:05:46 -0400

How is the "Total" field in an MBR's "Billing" tab calculated? I know
conceptually how it's done, but don't know the technical details (such as a
SQL script).

I need to run a script that updates all active MBRs' Send Method to "EMail -
Text" for any MBRs that pay monthly by "Postal Mail" and their monthly bill
is less than $50.00. Using the formula for the "Total" field would be
really handy here.

Thanks for any help...


For more information about this list (including removal) go to: