ACCESS the query results:

 
Type Comments 
1 aaa 
1 BBB 
2 test 
3 CCC 
3 DDD 

Hope to get the results:

 
Type Comments 
1 aaa, BBB 
2 test 
3 CCC and DDD 

Hope to connect the same type of comments,
Access, vb6.0 by use how to do,

CodePudding user response:

SQL itself do

You can load the raw data, and according to the type sorting
Then traverse the recordset, the same type of comments together, generating a two-dimensional array or set a new record

CodePudding user response:

You can write a macro VBA to realize in the ACCESS, is equivalent to actually write VB6 code

CodePudding user response:

refer to the second floor bcrun response:

ACCESS you can write a macro VBA to realize the ah, is equivalent to actually write VB6 code

Moderators can give a code, refer to,

CodePudding user response:

refer to the second floor bcrun response:

ACCESS you can write a macro VBA to realize the ah, is equivalent to actually write VB6 code

Another problem is that the access to write the vba function, if not in external calls, can only be used in the access,

CodePudding user response:

Is it not traverse after a merger with the item? As long as sorted by type, and then determine whether the same as the one on, is different on a new line

CodePudding user response:

refer to the original poster EmilyOu title:

big fairy help,,,

In bed waiting for you for so many years, experience countless great god, today finally see is a big fairy.

Big fairy heart endure, I do not know to be yellow or surnamed hu.