Access Query - Removing Duplicate Results

Asked Sep 11 '14 at 07:53

Active Sep 11 '14 at 07:53

Viewed 54 times

I have created an MS Access Database. I succesfully run a query on the database - but I want to compress duplicate fields:

Currently I get the results:

Page One | Link One | Function One
Page One | Link One | Function Two
Page One | Link One | Function Three

All I want the query to return is:

Page One | Link One | Function One Function Two Function Three

I believe that two sub-querys are required to concatenate the Link and Function columns. If so, how can I link these two sub-querys to my main query?

asked Sep 11 '14 at 07:53

JHarley

3

In an effort to help myself I have found the following article: http://allenbrowne.com/func-concat.html. – JHarley Sep 11 '14 at 08:41
Oddly enough, it is easier with ADO: http://stackoverflow.com/questions/92698/combine-rows-concatenate-rows/93863#93863 – Fionnuala Sep 11 '14 at 10:30
+1 for Allen Browne's code. It works really well. ;) – PaulFrancis Sep 11 '14 at 10:40
Yep, another +1 for Allen Browne. The concat function is cool. – maxhugen Sep 11 '14 at 12:10

0 Answers0