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!
Multiple Values
-
- NewLounger
- Posts: 24
- Joined: 23 Nov 2018, 20:24
Multiple Values
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78594
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Multiple Values
You write
"Sys_Info = NDI : 5896 ****in another column****"
Did you mean
"Sys_Info = NDI : 5896 ****in another row****"
"Sys_Info = NDI : 5896 ****in another column****"
Did you mean
"Sys_Info = NDI : 5896 ****in another row****"
Best wishes,
Hans
Hans
-
- NewLounger
- Posts: 24
- Joined: 23 Nov 2018, 20:24
Re: Multiple Values
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!
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!
-
- Administrator
- Posts: 78594
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Multiple Values
But you cannot have two columns named Sys_Info in the same record...
Best wishes,
Hans
Hans
-
- NewLounger
- Posts: 24
- Joined: 23 Nov 2018, 20:24
Re: Multiple Values
Yes, is there anyway around, other than the "make table"?
-
- Administrator
- Posts: 78594
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- NewLounger
- Posts: 24
- Joined: 23 Nov 2018, 20:24
Re: Multiple Values
Column1 ____ Column2 ________Column3
Memo_______ ACD :1234 _______NDI : 5896
Memo_______ ACD :1234 _______NDI : 5896
-
- Administrator
- Posts: 78594
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Multiple Values
What would you use it for? I'm afraid it doesn't make any sense to me.
Best wishes,
Hans
Hans