Multiple Values

CRISTOS
NewLounger
Posts: 17
Joined: 23 Nov 2018, 20:24

Multiple Values

Post by CRISTOS »

Hi all,
Happy New Year!
I would appreciate any insight on the attached Access table.
How to query the table so that I can get:

D_Info = Memo
Sys_Info = ACD :1234
Sys_Info = NDI : 5896 ****in another column****

Right now I doing a make table for ACD : 1234 and then querying again for NDI : 5896
Is there a way to do it in one step? Sometimes I have to repeat several times in case of 4 or 5 values.
Thanks!
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 75213
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Multiple Values

Post by HansV »

You write

"Sys_Info = NDI : 5896 ****in another column****"

Did you mean

"Sys_Info = NDI : 5896 ****in another row****"
Regards,
Hans

CRISTOS
NewLounger
Posts: 17
Joined: 23 Nov 2018, 20:24

Re: Multiple Values

Post by CRISTOS »

No, I mean another column.
So the query would look like:
D_Info Sys_Info Sys_Info
Memo ABC : 1234 NDI : 5896

Right now, I am overcoming this issue with a make table for AbC : 1234 the querying again with NDI : 5896
It is not that simple as I have several values in the Sys_Info and I need to repeat accordingly.
Thank you so much!

User avatar
HansV
Administrator
Posts: 75213
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Multiple Values

Post by HansV »

But you cannot have two columns named Sys_Info in the same record...
Regards,
Hans

CRISTOS
NewLounger
Posts: 17
Joined: 23 Nov 2018, 20:24

Re: Multiple Values

Post by CRISTOS »

Yes, is there anyway around, other than the "make table"?

User avatar
HansV
Administrator
Posts: 75213
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Multiple Values

Post by HansV »

I don't understand what the end result should be.
Regards,
Hans

CRISTOS
NewLounger
Posts: 17
Joined: 23 Nov 2018, 20:24

Re: Multiple Values

Post by CRISTOS »

Column1 ____ Column2 ________Column3
Memo_______ ACD :1234 _______NDI : 5896

User avatar
HansV
Administrator
Posts: 75213
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Multiple Values

Post by HansV »

What would you use it for? I'm afraid it doesn't make any sense to me.
Regards,
Hans