A table has four columns, column 1 is the customer name, column 2 is not (string format), in column 3 is this month amount, column 4 how practical column 3 month number minus column 3 last month

For example: the number of customers in this month - this month last month
A 10 January 2018
A February 12 12 2018-10

CodePudding user response:

With q ~ other database can use window function, the access will not use

CodePudding user response:

https://www.cnblogs.com/forerunner/p/SqlServer_Case-20151022.html

CodePudding user response:

2010 and above version can use macros to realize data, the following version can only use the query has been realized