Re: [MS_AccessPros] FIELD JOIN IN QUERY

 

Ade,

It seems your tables aren't normalized correctly. Can you provide more information about what types of values you are storing? I am picturing something like storing EmployeeIDs  (40 different employees) in any of the fields with headings/field names that equate to positions or roles. If this is somewhat like you system, rather than 5 fields, there should be 5 records.

How would you join? Can you provide some sample records and desired output?

Regards,

Duane Hookom

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Adeboyejo Oyenuga aoye_99@yahoo.co.uk [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Monday, October 30, 2017 6:02 AM
To: ms_access_professionals@yahoogroups.com
Subject: [MS_AccessPros] FIELD JOIN IN QUERY

 

I am looking for help to create a join between two tables. Fields 1-5 in the first table can take on about 40 different unique values, while Fields 1-3 in the second table can also take on the same number of unique values. Fields 1 to 3 can each equate to any of the values in Fields 1-5 in the 1st table.

Thanks.

Ade

TABLE1
FIELD1	FIELD2	FIELD3	FIELD4	FIELD5
TABLE2
FIELD1	FIELD2	FIELD3

__._,_.___

---

Posted by: Duane Hookom <duanehookom@hotmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

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

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___