Database Rows

[ismailkhannasar]

i have three Colmns in Table
Budget , Paid Amount and balance ... the paid amount should be Minus from Budget and save in that work in first rows but not work in second

Budget paid amount Balance
15000 5000 10000
15000 4000 11000 (second Instalment) but it should be Minuse from Balance


How to DO that

do u have any idea

[Amerlitong]

Edit table...
Change the Data Type of Balance column into Calculated and enter arithmetic expression that you want...

in your case...

(Budget - paid amount)

Cheers

[waqas]

dear if you want as below

Budget	Paid	Balance	Entrydate
15000	0	15000	01-Feb-13
0	5000	10000	02-Feb-13
0	4000	6000	03-Feb-13

try this query.

SELECT Table1.Budget, Table1.Paid, DSum("[Budget]-[Paid]","[table1]","cdate(format([entrydate],'dd-mmm-yy')) <=#" & CDate(Format([entrydate],'dd-mmm-yy')) & "#") AS Balance, Table1.Entrydate
FROM Table1
GROUP BY Table1.Budget, Table1.Paid, Table1.Entrydate
ORDER BY Table1.Entrydate;

[ismailkhannasar]

dear waqas sahib ,
i have two rows in table with name of Budget & Paid Amount but i make a query to exp1:[budget-paidAmount] . how to do in query is there any other way to do ,,, i m new in Access thanks

[waqas]

ok,

try this

SELECT Table1.Budget, Table1.Paid, DSum("[Budget]-[Paid]","[table1]","[paid] <=" & [paid]) AS Balance
FROM Table1
GROUP BY Table1.Budget, Table1.Paid
ORDER BY DSum("[Budget]-[Paid]","[table1]","[paid] <=" & [paid]) DESC;