Hello, can you tell me the use VBA SQL how can make such effect, best column (a combination of the summary) can summarize in descending order, thanks for the great god

Data source is probably like this, as well as the student's name and student ID I omitted, warrior, please help, thank you

CodePudding user response:

Want to use this column 1 grade cell merge, it is set in the grid control level, set up, the same adjacent cell content, will be combined, according to

2 sort more troublesome, because not press numeric size, the sequence of Chinese characters is the most simple method is to add a column, a serial number, for example, one of 11 to class one, grade, class two, grade one of 12... For 44 in class four grade four,

Among 3 summary more troublesome, actually need to make another query, get record to artificial (code) is inserted into the table,

CodePudding user response:

Excel do this work better,

CodePudding user response:

Please give a VBA can use SQL code

CodePudding user response:

Began keeping records in Excel macro, manual, complete the required function end record macros, press Alt + F11 key, check just record macro corresponding VBA code,