Have results show on one line per customer order?

[Number11]

Hello,

So i need to have the query show one line per customer order, the fields i have are as follows


Order_Date
Order_Number
Product_ID

results i see is

Order_Date Order_Number Product_ID
25/06/2024 592572 RRW01
25/06/2024 592572 RYTA02


i would like to see then like this is this possible?

Order_Date Order_Number Product_ID_1 Product_ID_2
25/06/2024 592572 RRW01 RYTA02

 

[plog]

Maybe, but its not going to be easy.

1. Does the Product_ID number matter? RRW01 could be Product_ID_1 just as easily as it could be Product_ID_2 in the above example, right? If you do care about the number they get, please explain the precedence rules.

2. Could you have duplicate records? Could this be in the table:

Order_Date Order_Number Product_ID
25/06/2024 592572 RRW01
25/06/2024 592572 RYTA02
25/06/2024 592572 RYTA02
25/06/2024 592572 RYTA02

If so, how would you like that displayed?

 

[June7]

It's possible. Options:

1. http://allenbrowne.com/func-concat.html

2. https://stackoverflow.com/questions/64400911/pivot-query-in-ms-access

 

[Gasman]

@theDBguy also has his version.

Code Snippets