Let's say I have a table with 2 fields. They are "EmployeeName" and "Manager" name. Now I want to have a query that will show EmployeeName, Manager, and then the Managers Manager name. So i am trying to have 3 levels of who reports to who in one record. Can I do some sort of lookup in the query to lookup a persons manager to show the managers manager? Hope this makes sense as its hard explain for me.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.