Query to lookup values from the same table

		Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
Query to lookup values from the same table

Access VBA Discuss using VBA for Access programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

July 10th, 2013, 08:41 AM

umesh.devs umesh.devs is offline

Registered User

Join Date: Jun 2013

Posts: 3

Thanks: 1

Thanked 0 Times in 0 Posts

Query to lookup values from the same table

Please help me with a query for the below mentioned problem:-

I have a table with employee ID, Email, Supervisor ID and H.R rep ID; I require a query which should give me the Supervisor's Email and H.R rep's Email by looking up the values for employee Id in the same table.
i.e. the query will have the same function of Vlookup in excel.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to insert values from Variable and table in single query	vinod_pawar1	Oracle	3	July 2nd, 2010 12:12 PM
Nested Loops in SQL Query values from table/set	miamikk	SQL Server 2000	1	August 31st, 2007 12:35 AM
lookup value in table	Vince_421	Access	16	February 13th, 2007 08:15 AM
Another ComboBox lookup query!	skinny	Access	1	September 28th, 2004 12:08 PM
Lookup Table Problem	mikericc	Access VBA	2	January 19th, 2004 07:11 PM