472,372 Members | 1,647 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,372 software developers and data experts.

Help with Access query to search multiple tables

I have created a database that has a main table with a description of different products. I have 5 other data bases that are linked sheets that have returns for the 5 different prduct groups. I'd like to have a query run and pull in all the products with their respective return. Is there a way to have it search for the same field on multiple sheets for example if you are looking for Product Sam, then it will check Return Sheet 1 2 or 3 to pull it in. I basically need it to look through the multiple tables and pull in the return respective to the product. This way I can have a master list of all products and all returns. I'm a newbie so let me know if I left anything out. This is the SQL:

SELECT AssetDescriptions.Name, AssetDescriptions.SubAssetClass, AssetDescriptions.SubStrategy, AssetDescriptions.Benchmark, AssetDescriptions.VehicleType, AssetDescriptions.ManagerFee, AssetDescriptions.IndividualMinimum, AssetDescriptions.InstitutionalMinimum, ManagerReturns.[3Y Ann ROR] AS [ManagerReturns_3Y Ann ROR], ManagerReturns.[3Y Std Dev] AS [ManagerReturns_3Y Std Dev], ManagerReturns.[3Y Shrp Rto] AS [ManagerReturns_3Y Shrp Rto], ManagerReturns.[3Y Beta] AS [ManagerReturns_3Y Beta], MutualFundReturns.[3Y Ann ROR] AS [MutualFundReturns_3Y Ann ROR], HedgeFundReturns.[3Y Ann ROR] AS [HedgeFundReturns_3Y Ann ROR], HedgeFundReturns.[3Y Std Dev] AS [HedgeFundReturns_3Y Std Dev], ETFReturns.[3Y Ann ROR] AS [ETFReturns_3Y Ann ROR], ETFReturns.[3Y Std Dev] AS [ETFReturns_3Y Std Dev], ETFReturns.[3Y Shrp Rto] AS [ETFReturns_3Y Shrp Rto], ETFReturns.[3Y Beta] AS [ETFReturns_3Y Beta]
FROM ((IndexDes LEFT JOIN IndexReturns ON IndexDes.CANDIDATE_NAME = IndexReturns.CANDIDATE_NAME) RIGHT JOIN (((AssetDescriptions LEFT JOIN HedgeFundReturns ON AssetDescriptions.CANDIDATE_NAME = HedgeFundReturns.CANDIDATE_NAME) LEFT JOIN ManagerReturns ON AssetDescriptions.CANDIDATE_NAME = ManagerReturns.CANDIDATE_NAME) LEFT JOIN MutualFundReturns ON AssetDescriptions.CANDIDATE_NAME = MutualFundReturns.CANDIDATE_NAME) ON IndexDes.Name = AssetDescriptions.Benchmark) LEFT JOIN ETFReturns ON AssetDescriptions.CANDIDATE_NAME = ETFReturns.CANDIDATE_NAME;

This pulls in all my data in different columns. I was wondering if there was a way to pull in respective data into one column since they all have the same column name. So all the data on the AssetDescriptions page shows up and then under the 3Y Ann ROR will have the return in one column if the product is from MutualFundReturns or ETFReturns.
Aug 6 '07 #1
0 1458

Sign in to post your reply or Sign up for a free account.

Similar topics

by: LRW | last post by:
Well, I have another question that's hard to ask, so I may end up over explaining the question. I have about 40 tables, all with a similar column structure. I want to be able to search through...
by: JIM WHITAKER | last post by:
Are there any good PHP scripts or pre written programs that deal with a complex database? Let me explain: I'm in truck dispatch, and we've moved all tables to mysql and access them on a network...
by: Melissa Kay Beeline | last post by:
OK, here's the sitch : we have an access control system at work that registers ever entry/exit of every employee. I recently made some queries in Access so the ppl in HR could make reports (who...
by: Tarun Mistry | last post by:
Hi all, I have posted this in both the c# and asp.net groups as it applies to both (apologies if it breaks some group rules). I am making a web app in asp.net using c#. This is the first fully OO...
by: Robert | last post by:
I am an attorney in a non-profit organization and a self-taught programmer. I'm trying to create a client db that will allow me to search for potential conflicts of interest based either on Social...
by: OdAwG | last post by:
Just some questions regarding tables. I am new Access Database and need a little help. I have the following data listed below 01. I have a table called tbl_Customer with the following...
by: 663scott | last post by:
Hi I am pretty new to ACCESS. I have created some small databases previously. I need to run a simple query searching for a USERNAME which will gather information from five to ten tables containing...
by: MMcCarthy | last post by:
The more data you include in your tables the more you will need to have indexes to search and sort that data. However, there is a balance between having enough indexes and too many. Too many...
by: jcf378 | last post by:
Hi all-- Does anyone have any insight as to how I might create a search form that allows a user to select criteria based on any related table in the whole database. The search form I have now only...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web server and have made sure to enable curl. I get a...
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...
by: Ricardo de Mila | last post by:
Dear people, good afternoon... I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control. Than I need to discover what...
by: Johno34 | last post by:
I have this click event on my form. It speaks to a Datasheet Subform Private Sub Command260_Click() Dim r As DAO.Recordset Set r = Form_frmABCD.Form.RecordsetClone r.MoveFirst Do If...
by: ezappsrUS | last post by:
Hi, I wonder if someone knows where I am going wrong below. I have a continuous form and two labels where only one would be visible depending on the checkbox being checked or not. Below is the...
by: jack2019x | last post by:
hello, Is there code or static lib for hook swapchain present? I wanna hook dxgi swapchain present for dx11 and dx9.
by: DizelArs | last post by:
Hi all) Faced with a problem, element.click() event doesn't work in Safari browser. Tried various tricks like emulating touch event through a function: let clickEvent = new Event('click', {...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.