on 09-25-2012 7:25 PM
Hi guys,
Can anyone tell me is it possible to do arithmetic operations over two values in a form,before saving to the DB?
ie,for example,I want to multiply the "items per Unit" value and "Unit price",which is not saved in the DB, and fill it in a user defined field.
Is it possible?If yes how will be the Query to be written?
Expecting faster replies....
Thanks in advance
Akhin
Hi Akin,
Yes you can achieve this with applying a Formatted Search on your User defined field.
SELECT $[$ RDR1.Quantity] * $[$ RDR1.Price] FROM RDR1
You can modify this query according to your need.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.