Hi All...
I have a form based on a query to get the sum of expenses.
The fields are No., Amount, Tick, Description.
I build expression in query in a way that, if tick is -1 then + else -.
e.g. Amount 1000 Tick + it's 1000
Amount 200 Tick - it's -200 etc.
I created an Unbound Field in the form (Tabular form) to calculate the sum of Amount. So, I should get in the first record 1000 and in second record 800, which is (1000-200) and so.
It's not working..
Any help please

Look up help on RunningSum, I suspect you'll have to do it in the query to display on a tabular form, as opposed to on the form if it's continuous.

Yes I want to do it in a tabular form.
This can be done easily in Excel, and therefore I think it must be done in Access as well.
The Sum will give a result of the whole records and not for a specific one.
Will anybody join for help please