troubleshooting Question

Need...subquery?

Avatar of sirbounty
sirbountyFlag for United States of America asked on
Microsoft Access
28 Comments1 Solution245 ViewsLast Modified:
I'm using the query below...and it works fine...but I ran into a slight snag today...
There sometimes occurs a need to get the email address of the Manager found.  I could do it if I could rerun another query with the ID found in ManagerID field (Select WorkEmail From tbl_Employee WHERE EmpID=....ManagerID from previous query)... how can I do this, or can i?

SELECT EmpID, LogDate, ManagerID, WorkEmail, tbl_Log.FileID FROM tbl_Log, tbl_Data, tbl_Employee WHERE tbl_Log.fID=tbl_Data.fID And tbl_Employee.ID=mid(EmpID,2) And LogDate Between #8/1/2005# And #8/31/2005# AND EmpID='" & Mid(strFile, 1, 7) & "'" & " GROUP BY EmpID, fID, LogDate, ManagerID, WorkEmail, tbl_Log.fID
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 28 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 28 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros