[FONT=Verdana, Arial, Helvetica]have created a database for Payments entry for various parties in which I
have created a Select Query for obtaining the Bill Details (Advance, Running
& Final Bills) such as Bill value, Advance Paid, Bill Accounted, TDS, WCT,
Balance Payable. I have given calculations based on Bill Value(s) in this
query for all these bills (Advance, Running & Final Bills).
When I enter Bill Values for all Advance, Running Bills details only It is
showing the Value in "Advance Paid" coloumn. Whereas if I enter the Bill
Values in only in Advance Bill, there is no display in "Advance Paid" coloumn
in the Final Bill Value section. I have given the calculation for obtaining
the "Advance Paid" coloumn in the Final Bill section like this:
Adv Paid 3rd RA(Gross): CCur([Party Payments].[Advance Bill Value])+([1st RA
Bill Accounted])+([2nd RA Bill Accounted])+([3rd RA Bill Accounted]).
I dont know whether I can give like this or not.
Is there any other way of getting the result.
Pls help on this. [/FONT]
have created a Select Query for obtaining the Bill Details (Advance, Running
& Final Bills) such as Bill value, Advance Paid, Bill Accounted, TDS, WCT,
Balance Payable. I have given calculations based on Bill Value(s) in this
query for all these bills (Advance, Running & Final Bills).
When I enter Bill Values for all Advance, Running Bills details only It is
showing the Value in "Advance Paid" coloumn. Whereas if I enter the Bill
Values in only in Advance Bill, there is no display in "Advance Paid" coloumn
in the Final Bill Value section. I have given the calculation for obtaining
the "Advance Paid" coloumn in the Final Bill section like this:
Adv Paid 3rd RA(Gross): CCur([Party Payments].[Advance Bill Value])+([1st RA
Bill Accounted])+([2nd RA Bill Accounted])+([3rd RA Bill Accounted]).
I dont know whether I can give like this or not.
Is there any other way of getting the result.
Pls help on this. [/FONT]
