Ms access concat8/1/2023 The following SQL with the VBA function SELECTĬoncatRelated("Grade","subjects","SubjectName='" & SubjectName & "'") AS result Given this table structure subjects table You just need to add the code to a module within Access and then you can use that function within SQL queries within Access. One has already been written by Allen Browne here. Or you could write a VBA function to use in Access to do it. I would be inclined to pull the data back as you have done in you GROUP BY in the question, and then concatenate the number values for each subject in you asp.net code. Join collection of objects into comma-separated string I believe you are looking for something like this.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |