Search results

Hi everyone I have two tables which I join using a LEFT JOIN statement. Table1 contains more entries then Table2. All unique entries in Table2 also appear in Table1. Thus the JOIN statement is as follows: FROM (Table1 LEFT JOIN Table2 on Table1.IDCode = Table2.IDCode) There are a few fields...

Hi everyone I am looking for a way to merge duplicate rows of a table. I suspect that the query wizard might be able to help. I include some sample data below: [Customer ID] [Customer_Name] [Address] [Phone] [1001] [Bob Smith] [Main Rd 1, NY] [555-1234] [1002] [John Miller] [Oak Ln 2, NY] []...

Hi everyone I am trying to complement data from one table with data from another. Table 1 [Key][Customer_Name][Address][Phone_Number] Table 2 [Key][Customer_Name][Address][Phone_Number] I would like to update the details (Address, Phone Number) in Table 1 using the data in Table 2. However...

Hi everyone I have the following (simplified) normalised data table: [Account] [SrcUD2] [Amount] col1 row1 1000 col1 row2 500 col1 row3 500 col1 row4 1000 col1 row5 1000 col1 row6 0 col1 row7 1000 col1 row8 1000 col1 row9 0 col2 row1 100 col2 row2 1000 col2 row3 200 ... I use the query...

Hello everyone I have a normalised table containing the following fields: <Unique ID> <Fund Name> <Date> <Return> The data are time series denoting the monthly performance of investment funds. Funds can have any number of observations (e.g. March 1997 to June 2005). In addition, some funds...

Hello everyone, I am looking to create a query that adds a new field to the resulting table. The field should be 'Yes/No' and for every entry the default should be 'Yes'. The query looks something like this: Select .*, [here the new field] From MyTable1 Union Select .*, [here the new...

Hi everyone, I have a normalized table containing the dates and associated monthly performance of several investment funds. The date range is 07/01/1990 to 06/01/2010. Most funds have a performance track record that is less than the maximum 240 observations. Some investment funds also have gaps...

Hi everyone, I have a problem with one of my queries. I have two normalized tables (PerformanceA, PerformanceB) containing the performance of various investment funds. Both tables have the same fields: [Fundname] [Fundcode] [Date] [Return] Obviously, one fund may have many return observations...

Hello everyone, I have the following normalized table containing the return observations for different dates and various investment funds. The table looks as follows: [Fund1] [Code1] [Date1] [Return1] [Fund1] [Code1] [Date2] [Return2] [Fund1] [Code1] [Date3] [Return3] ... [Fund1] [Code1]...

Hi everyone, i would like ot eliminate duplicate entries from two tables. Both tables contain a field called name which is unique within each table but may have duplicate observations across the two tables. The other field entries may not be identical. Consequently, a UNION query does not...

Hi everyone, I have the following (normalized) table 'mytable' containing 4 fields: [Fund] [Date] [Return] FundA 1001 Date1 Return1 FundA 1001 Date2 Return2 FundA 1001 Date3 Return3 ... FundA 1001 DateN ReturnN FundB 1002 Date1 Return1 FundB 1002 Date2 Return2 FundB 1002 Date3 Return3 ...

Hi everyone, I have the following table named 'information' that contains the names and codes of investment funds in two fields: <Name> <Code> Name1 Code1 Name2 Code2 ... NameN CodeN A separate normalized table 'performance' contains the performance of said funds: <Name> <Code>...

Hi everyone, I have the following three tables: Table Assets Code AUM_Date1 AUM_Date2 ...AUM_Date200 1001 1002 ... 7000 this table contains the assets-under-management (AUM) for 6000 investment funds for 200 different months (i.e. 1200000 obs) Table Returns Code ROI_Date1 ROI_Date2 ...

Hi everyone, I have a problem with one of my queries. I suspect that it has to do with max settings for statements and characters. What are the respective maximum allowable numbers for both? Is there a workaround? I understand that I could simply split up the queries but I am running them from...

Hi everyone, I have a table in my access database that looks as follows: Fname Fcode Date1 Date2 Date3 Date4 ...... DateN FundA 10001 30000 20000 12000 14000 ...... xxxxx FundB 10002 40000 50000 60000 70000 ...... xxxxx FundC 10003 99999 88888 77777 66666 ...... xxxxx ....... FundXYZ The...

Hi everyone, I have the following SELECT statement below: SELECT Performance.ID As Code The entries for the Field 'Code' look something like this: 6473 4596 304 21 340 In the query I would like this to be changed to: 6473 mutual 4596 mutual 304 mutual 21 mutual 340 mutual What...

Hi everyone, I have the following problem: I have two access databases that contain the same tables and fields within (it is an entirely different matter why the two have not been combined yet...). One of the tables is titled 'Information' and the field in question is 'UserDescription' (set as...

Hi everyone, I have the following database with two tables named 'Information' and 'Performance'. I would like to run a Union-query to combine the information in the two tables. From the first table I include 'ID' as well as 'Fundname', from the second table I would like to include 'Date'...

Hi everyone, I would like to create a bibliography in access. So far, I have the following: Table SOURCE <Authorname> <Article> <Journal> <Year> Table AUTHOR <First Name> <Middle Name> <Last Name> I would like to create a form to enter new data with the four fields of Table SOURCE. A new...

Hi everyone, I have the following simple question. How can I restrict the field entries in a table to a few selected values? For example, I have the field name 'Month' and would like to restrict the entries to: January, February, March, etc... In the table I would then like to have a drop-down...