Hi Everybody,

I have one table which have four field :

Srno
value1 (number)
value2 (number)
value3 (number)

Now i want to creat query of this table that value1,value2,value3 display calculating

value1 + 0.09
value2 - 0.045
value2 - 0.005

And second time when i run query value1,value2,value3 display calculating

value1 - 0.05
value2 + 0.078
value2 - 0.008

And second time when i run query value1,value2,value3 display calculating

value1 - 0.09
value2 - 0.089
value2 + 0.002

I mean every time when i run query value1,value2,value3 display different data according to previous result.

thanks.

What is the object of the exercise?

I have device & i want to give them unique serial no. & its reading. so i want different reading for diff. serail no.