0

I am building a query that looks for a contract number in a second table of which there will be multiple results. But what i want to do is instead of returning a second row i want it to look like below

Contract No | Result 1 | Result 2 | Result 3

rather than

contract no | result 1

contract no | result 2

contract no | result 3

How to do this?

The concatrelated vb is not a viable option for us within the business that i work.

Cœur
  • 37,241
  • 25
  • 195
  • 267
Pferd676
  • 21
  • 8
  • Possible duplicate of [Combine values from related rows into a single concatenated string value](http://stackoverflow.com/questions/13278590/combine-values-from-related-rows-into-a-single-concatenated-string-value) – Andre Nov 08 '16 at 13:39
  • It sounds like you need to pivot the results of the second query - look here and see if it helps http://stackoverflow.com/questions/16546305/pivoting-data-in-ms-access – Aron Nov 08 '16 at 14:30
  • I gave in and used the concatenate vb script but i would like to be able to limit the to only concatenate the first 3 results. – Pferd676 Nov 08 '16 at 15:43
  • Possible duplicate of [Pivoting data in MS Access](https://stackoverflow.com/questions/16546305/pivoting-data-in-ms-access) – Parfait Sep 03 '17 at 14:27

0 Answers0