i have this table
a b
-------------
10 0
20 5
0 10
i want this result from my query
a. b c
10 0 c=a1-b1 =====> 10
20 5 (c1+a2)-b2 ===> 30-5=25
0 10 (c2+a3)-b3 ===> 25-10=15
its just like you working on excel worksheet. .
i have this table
a b
-------------
10 0
20 5
0 10
i want this result from my query
a. b c
10 0 c=a1-b1 =====> 10
20 5 (c1+a2)-b2 ===> 30-5=25
0 10 (c2+a3)-b3 ===> 25-10=15
its just like you working on excel worksheet. .
Then work in excel. access is a different animal.
You can sorta do it with a query and calculated fields.
how?................
It's not easy without careful use of expressions.
Put simply, Access queries are not designed so that one row can reference values in other rows.
As Ranman said, Access is not Excel, and there are certain things that Excel can do (and is designed to do) that Access cannot do (at least not easily). Your requirement is one of them. If spreadsheet-type operations are a major part of your requirement, then you should use Excel.
thank you very much ill ask vba guys im sure they can do it with recordset thing