UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
2 Pages V < 1 2  (Go to first unread post)
   Reply to this topicStart new topic
> Transpose / Transforming Data Format, Access 2016    
 
   
ADezii
post Sep 7 2019, 02:28 PM
Post#21



Posts: 2,679
Joined: 4-February 07
From: USA, Florida, Delray Beach


Now I truly believe that I am going crazy since I could not find the Access File! pullhair.gif
Go to the top of the page
 
isladogs
post Sep 7 2019, 03:09 PM
Post#22


UtterAccess VIP
Posts: 1,704
Joined: 4-June 18
From: Somerset, UK


I really am making an utter pig's ear of this!
Amended zip file now added to the previous post and to this one!

Attached File(s)
Attached File  NormalisedStructureData.zip ( 55.38K )Number of downloads: 11
 

--------------------
Go to the top of the page
 
ADezii
post Sep 8 2019, 01:40 PM
Post#23



Posts: 2,679
Joined: 4-February 07
From: USA, Florida, Delray Beach


Nice approach, isladogs. But I am still a little confused, which is very easy for me! iconfused.gif How do you now arrive at the requested Output/Format? I am still envisioning a Results Table with 50 Fields (MAX of 5 Levels * MAX of 5 Users per Level * 2 (UserID and Username @ each intersection of Level/User).
QUOTE
Ideally, we need only 1 row of data for each cost centre with each UserID and Username going alongside it with a column heading that relates to their access level. Something Like

This post has been edited by ADezii: Sep 8 2019, 01:44 PM
Attached File(s)
Attached File  Reformatted_example.jpg ( 60.81K )Number of downloads: 8
 
Go to the top of the page
 
isladogs
post Sep 8 2019, 02:27 PM
Post#24


UtterAccess VIP
Posts: 1,704
Joined: 4-June 18
From: Somerset, UK


If you go back to post #18, I said I hadn't attempted the final part but that my original comment about not needing code was probably incorrect for that part.
It would certainly be a lot of work using several queries to get to the final 'desired' outcome.

The output the OP wants is a spreadsheet layout and I think would be better done in Excel.
If I was more proficient in Excel/PowerQuery, I might attempt it.

As it is, I still think your pure Access solution was extremely impressive as I originally stated hat_tip.gif

--------------------
Go to the top of the page
 
ADezii
post Sep 8 2019, 04:33 PM
Post#25



Posts: 2,679
Joined: 4-February 07
From: USA, Florida, Delray Beach


@isladogs:
Thanks for the clarification.
Go to the top of the page
 
2 Pages V < 1 2


Custom Search


RSSSearch   Top   Lo-Fi    21st October 2019 - 05:18 AM