Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by dwinokur
-
How to update/add records in a query based on two other queries?
Thanks for the pointer. While the article was educational, I have not been able to figure out how to solve my problem using joins, inner or outer. The problem is that I'm ultimately trying to achieve a *union* of tables/queries, to which new records cannot be added. However, I have come up...- dwinokur
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
How to update/add records in a query based on two other queries?
I have a query that is based on 3 tables, as follows: Industry Sectors ---------------- Sector ID Sector Sector Description Companies --------- Company ID Sector ID Company Employees Revenue Growth Rate Headquarters Companies Investors Junction ---------------------------- Company ID Investor...- dwinokur
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
