Re: Forms4.5 How to Calculate subtotal while making Data entry.

What you need to do is on entry of the field store a copy of the field value (or zero if it's null) and then write the validate trigger to add the current value to the total and then subtract the old value.

You'll also need to write some code to calculate the value on a query. say pre-query to set the total to zero and post-query to add the current value to it.

--
Alan D. Mills

nagparag_at_hotmail.com wrote in message <6sr1nh$n3b$1_at_nnrp1.dejanews.com>...
>Your Kind attention please.
>I am having a block defination with multiple record display( 5 Records ).
>Say for Example EMP table
>Columns Such As Ename and Salary.
>While adding records to emp table through Forms45 I want
>the subtotal of what all Salary is entered.
>
>John 3000
>Scott 4000
>
> Total 7000
Received on Mon Sep 07 1998 - 06:09:58 CDT