Recent content by fboehlandt

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 there thanks for your quick response. Just a few comments: - Customer ID is not the PK - The problems result from poor data entry that did not address the possibility of row duplication - I agree with your assessment of non-NULL fields which will require to prioritize data from one row over...

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...

Thanks Nigel, that is what I was looking for (Code 2). Greatly appreciated

Hm, okay thanks. I didn't mean to create a table but I suppose the easiest solution is to create one, create a frield and run a code over it to fill it. Cheers

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, thanks for your quick response. Your combined query is working very well. Do you have any recommendations to speed up execution? (e.g. splitting the query etc...)

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...

@Bob you are absolutely right, of course. However, as usual the choice of database design does not reside with me. I get the (two) database snapshots from an external database provider. The databases are idenitcal with respect to the number of tables and the fields within. I would like to...

Not quite, that would yield all investment funds and their respective performance between start and end date. Not all fund will have a continuous track record between start and end date (i.e. some observations will be missing). I need all funds with continuous track record only. Thus, I run one...

Again: Originally, there were two databases. Now, it is one. I have imported all tables from two databases into one. Then, I ran a UNION query to combine the tables. Don't worry about the primary keys now. This is not relevant. I don't seem to get my point across so I will see if I cannot narrow...

Merry christmas, here the table 'Information': [Fundname] [Fundcode] [Description] Here, Fundcode is the primary key. Like autonumber, fundcode is a random unique code assigned to each investment fund. The table 'Performance' looks as follows: [Fundname] [Fundcode] [Date] [Return] Here...