Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a database table which has 2 fields orderDate and orderAmount. Now I need to create date range as from-order-date and to-order-date in 2 separate list box by using orderDate field. And also need sum(orderAmount) when customer select from-order-date and to-order-date from those list boxes.
| orderDate | orderAmount |
|---|---|
| 1/1/2015 | 1000 |
| 14/2/2015 | 4500 |
| 31/3/2015 | 200 |
| 30/4/2015 | 800 |
| 14/6/2015 | 3500 |
Anyone please provide video or process step by step.
I have QV personal edition. Can you give any video, so that I can understand this answer.