[MS_AccessPros] Unique values in 1 query

 

Hello all,

I have a table with reports to information. the table has columns with each of the levels of Reporting (see below).

I need to create a query that will get the unique values of all the levels into one column. It will be used as the row source for a combo box.

Is there a way of doing it in one query or do i need to create multiple queries?

Thank You

Jim Wagner

for example

Level 5 has 2 employees which is the executive leaders

Level 4 has 9 employees which are Directors

Level 3 has 20 employees which are the Supervisors

Level 2 has 40 employees which are the Assoc Supervisors

Level 1 has 33 employees which are the Leads.

__._,_.___

---

Posted by: luvmymelody@yahoo.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___