Post reply

Formula Field

  • October 21, 2005 at 11:02 am

    #111308

    Folks

    I want to have a field in my table that keeps the count of how many times a particular field was updated...

    For eg.

    Account# Balance Count

    100234 2000 1

    If the amount is updated ...suppose 3000

    then my table should be

    Account# Balance Count

    100234 3000 2

    Can anyone tell me what would be the best way to do this...

    Regards

    Jol

    Kindest Regards,

    Joel

  • October 21, 2005 at 11:36 am

    #599214

    You'll have to create an update trigger and add to the actual count, the number of times that the row was updated in the batch (can be more than once). That info can't be kept in a formula column unless you have some sort of auditing process in place.

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

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