0

I found this question on Stack Overflow and it is my exact issue. It was solved, but I am using an Access database and apparently some of the functions described in the solution are not available in Access. How can I achieve that result in Access?

I have a table as follows:

ID  User  PageURL  
1    Me     ab     
2    Me     cd     
3    You    xy     
4    You    st

I want to group by User such that I end up with something like:

User  PageURL  
Me    ab, cd     
You   xy, st

As you can see, the column PageURL is combined together separated by a comma based on the group by.

Community
  • 1
  • 1
Ollie
  • 337
  • 3
  • 6
  • 17
  • Can you split your table into 3 separate tables? User, Page and UserPage. So you can query user and concatenate the linked page values. – robaudas May 06 '16 at 20:11
  • I guess so..... I hadn't thought of that. Would that make it easier to combine PageURL and group by User? – Ollie May 06 '16 at 20:13
  • Check out `ConcatRelated()`. There are many Stack Overflow examples ... here is one: [Unable to get Allen Browne's ConcatRelated to work on a simple table](http://stackoverflow.com/q/27913856/77335) – HansUp May 07 '16 at 15:21

0 Answers0