Calculate problem in query

[crujazz]

Hello everybody,



I do have a little problem.

I have a table with 3 colomns, (Date, Pressure Left, Pressure Right)
Date Pressure Left Pressure Right
12-06-09 300 188
15-06-09 300 170

My problem is that i want to calculate the difference between Pressure Right ( 188 bar - 170 bar) for each time i enter a new row with date, left and right.

Could some point me in the right direction?

Thanks

[tinytree]

maybe It will use programming to solve your question.

[RuralGuy]

Use the Querybuilder to create a query that gives you the difference on each record.