Will you please help me to write a query for same database.
Query is: I have to add a calculated coulmun in my table called 'pips' and How it will calutate is as follows:
- I have pairs of trades in the table and subtraction of 'price' of pair is called pip of that row.
-We can use 'key' coulum to find a pair. 'Key' has this type of value: 244/1/-9934863, So each pair would have the first and last part of the value same. (for example if we have a pair, its values would be 244/1/-9934863 and 244/0/-9934863). These 0's and 1's denote for 'sell' and 'buy'.
- then Subtract the pair (large value - small value)
- then i have to figure out that what is the pair name from 'description' column. If its part of value contains 'JPY' then i have to multiply the subtracted value with 100 otherwise it will multiplied by 10,000.
It is very difficult for me, i don't know how to start it. I need these calculated pips in my table field, so that when i run my '1st dec' form, i will display the calculated pips in the subform with other coulmns.
Thanks
Query is: I have to add a calculated coulmun in my table called 'pips' and How it will calutate is as follows:
- I have pairs of trades in the table and subtraction of 'price' of pair is called pip of that row.
-We can use 'key' coulum to find a pair. 'Key' has this type of value: 244/1/-9934863, So each pair would have the first and last part of the value same. (for example if we have a pair, its values would be 244/1/-9934863 and 244/0/-9934863). These 0's and 1's denote for 'sell' and 'buy'.
- then Subtract the pair (large value - small value)
- then i have to figure out that what is the pair name from 'description' column. If its part of value contains 'JPY' then i have to multiply the subtracted value with 100 otherwise it will multiplied by 10,000.
It is very difficult for me, i don't know how to start it. I need these calculated pips in my table field, so that when i run my '1st dec' form, i will display the calculated pips in the subform with other coulmns.
Thanks