As title, with links to the SQL server, assuming three A, B, C material, according to the material sort by date, first open software run correctly, return again to open the statistical aberration, should be the following order:
1-1 A
1-2 A
1-3 A
1-1 B
1-2 B
1-3 B
1-1 - C
1-2 - C
1-3 C
Return window again statistics is to always have A material not by date, A date inserted into other materials, this is what problem, leading to? Code for a very long didn't post
1-1 A
1-1 B
1-2 B
1-3 B
1-2 A
1-3 A
1-1 - C
1-2 - C
1-3 C

CodePudding user response:

Want to order get a normal order by soon come,

CodePudding user response:

normal count
statistics is wrong again, but each is different, unless the software all over again open the statistics is right,

CodePudding user response:

By date range statistics, the X represents a stock before, each of the remaining should correspond to the material, if there is no word on behalf of no inventory

CodePudding user response:

The table has a primary key or something?

CodePudding user response:

reference 4 floor mathsfan response:

this table has a primary key or something?

this table is not the primary key

CodePudding user response:

That put the primary key, please try again,

CodePudding user response:

The key is the SQL statement:
The order by 'material name,' date '

CodePudding user response:

refer to 7th floor lyhoo163 response:

key is SQL statements:
Date of the order by 'material name', ' '

I just opened the first is why the order by the date material name and the date is correct?