Post reply

calculations

  • July 8, 2005 at 6:11 pm

    #109806

    hi guys?

    Can you guys please advise me on wich way is best to calculate interest for customers every month and save the intrest earned that month in some sort of a history  table for every customer that earned interest?

  • July 8, 2005 at 6:50 pm

    #572667

    Just create a table like this I assume :

    Account_id int?

    DateInterest smalldatetime

    Amount decimal(12,2)

    But this seems to me like this should be part of a transaction table with transaction type... but then again I don't know the software and I've never worked for a bank.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply