calculate a difference between two values
Hello.
I would like to calculate in querie a difference between two values and I have no idea how to do that.
Please help me.
My querie look's like that.
id_field | id_machine | counter | distinction
----------------------------------------------
....1...........1...............A1................A1......
....3...........1...............B1..............B1-A1....
....4...........1...............C1..............C1-B1....
....2...........2...............A2................A2......
....5...........2...............B2..............B2-A2...
....6...........3...............A3.................A3.....
...10..........3................B3...............B3-A3
Thanks for help
Hello.
I would like to calculate in querie a difference between two values and I have no idea how to do that.
Please help me.
My querie look's like that.
id_field | id_machine | counter | distinction
----------------------------------------------
....1...........1...............A1................A1......
....3...........1...............B1..............B1-A1....
....4...........1...............C1..............C1-B1....
....2...........2...............A2................A2......
....5...........2...............B2..............B2-A2...
....6...........3...............A3.................A3.....
...10..........3................B3...............B3-A3
Thanks for help
Attachments
Last edited: