2019/1/24 258012
2019/1/23 228374
2019/1/22 156399
2019/1/21 296897
2019/1/18 124688
2019/1/17 394043
2019/1/16 108640
This is my query table, summary the daily total amount of sales, I would like to add a column in the lookup table, know income amount every day, 24, is 258012 yuan, for example, 23, is 228374 yuan, behind 2019/1/24 income is 258012-228374=29638 yuan, excuse me each warrior, this should be in the query table do?
CodePudding user response:
I also want to know whether there is a simple way to do that is similar to the query, I by vba to do, can do a function, add a column in a query, use a custom function to get the result, but the amount of data a little more slowly, also can be in the output (when I am with a ListView output) with an array of circulation, the speed is not bad, no matter what method should be sorted first, now I'm using a custom function to sort for date,CodePudding user response:
Besides VBA, I used a way of generating a query 2, date, the current query and query 2 reproduction query 3, subtracting the amount, but not tested a large amount of data