Sqlite calculating
If you need help with a project or need to know how to do something specific in VB.NET then please ask your questions in here.
Forum rules
Please LOCK your topics once you have found the solution to your question so we know you no longer require help with your query.
Please LOCK your topics once you have found the solution to your question so we know you no longer require help with your query.
2 posts
Page 1 of 1
Hello,
Can someone help me out please
i can't get it to work
like we have 26.731,32 we want to calculate that by 318.23 and then get the output
and then we don't know how we can use that output again to calculate it again by the next record
the first record sum shows as: 26.413,09
the mypayments.mamount records have only 318.23 as amount
and the basic of this account mydebtsborrow.mamount has 26.731,32
so when we calculate it all i need at the end of the data 19.730,26
Thank you
Can someone help me out please
i can't get it to work
Code: Select all
its keep the same value :( attributes = "mypayments.num,mypayments.mdate,mypayments.mamount,mydebtsborrow.mamount,mydebtsborrow.mamount - mypayments.mamount"
like we have 26.731,32 we want to calculate that by 318.23 and then get the output
and then we don't know how we can use that output again to calculate it again by the next record
the first record sum shows as: 26.413,09
the mypayments.mamount records have only 318.23 as amount
and the basic of this account mydebtsborrow.mamount has 26.731,32
so when we calculate it all i need at the end of the data 19.730,26
Thank you
visit us on:
http://www.softpedia.com/get/System/Lau ... -Run.shtml
Check it out ! http://www.softpedia.com/publisher/I-A- ... 90017.html
Check it out ! http://www.softpedia.com/get/Desktop-En ... lock.shtml
http://www.softpedia.com/get/System/Lau ... -Run.shtml
Check it out ! http://www.softpedia.com/publisher/I-A- ... 90017.html
Check it out ! http://www.softpedia.com/get/Desktop-En ... lock.shtml
This is the code in sqlite itself
but i can't manage it to work what we are looking for :(
but i can't manage it to work what we are looking for :(
Code: Select all
SELECT mypayments.num,mypayments.mamount,mydebtsborrow.mamount,mydebtsborrow.mamount - mypayments.mamount as TOTAL FROM mypayments left JOIN mydebtsborrow ON mydebtsborrow.num = mypayments.mnum WHERE mypayments.mnum=6 ORDER BY mypayments.num DESC ;
visit us on:
http://www.softpedia.com/get/System/Lau ... -Run.shtml
Check it out ! http://www.softpedia.com/publisher/I-A- ... 90017.html
Check it out ! http://www.softpedia.com/get/Desktop-En ... lock.shtml
http://www.softpedia.com/get/System/Lau ... -Run.shtml
Check it out ! http://www.softpedia.com/publisher/I-A- ... 90017.html
Check it out ! http://www.softpedia.com/get/Desktop-En ... lock.shtml
2 posts
Page 1 of 1
Copyright Information
Copyright © Codenstuff.com 2020 - 2023