Access help with query - find last value in row of record

[kingerick]

hello all,
learning Access and I'm stuck. Is there a way to create a calculated field to find the last value in a row of a record? What I have is an employee DB so the unique is the employee. along with other data, i have management hierarchy to the top as fields manager level 1, manager level 2, manager level 3 down to manager level 15. the way it works is manager 1 is the highest level of management and it goes down in number until we hit the immediate (or reporting to) manager. so depending on the employees level and dept or line of business, they will have a different number of management above them. example: a VP will only have the President above them but a entry level person will have a manager then director then regional director then regional SVP then a VP then a pres. What I want to do is create a field in the query to show the first listed manager which would be their "reports to" manager. I know this is doable in excel but I want to make this happen in the query if it's possible.

employee# | employee name | management level 1 | management level 2 | management level 3 | management level 4 | management level 5 | --desired result--
0001 | A.smith | H. Jones | A. James |blank |blank | blank |A. James
0002 | B.smith | H. Jones | A. James |A. Frank |D. Wade | blank |D. Wade
0003 | B.smith | H. Jones | A. James |A. Frank |blank | blank |A. Frank

thanks in advance for any help you can provide

 

[HiTechCoach]

Unfortunately your table is designed like an spreadsheet (not normalized) and not a relational database. In a well normalized databse this would be very simple.

This example may help:


Access Treeview Example

Displaying Hierarcharical Data. This example uses Employees and the people under them