Search results

  1. L

    I forgot what my query does. Can someone explain it?

    It's been month's since i wrote this thing and have no idea what it does or why, other then it selects a bunch of distinct rows from a table with many duplicate entries. SELECT First([import_table].[server_name]) AS [server_name Field], First([import_table].[filesystem]) AS [filesystem Field]...
  2. L

    Query to merge two tables based on common entries?

    Say I have table A with fields 1, 2, 3, 4, and 5 and then a table B also with fields 1, 2, 3, 4, and 5. I want to merge table A into table B. I want to take entries 3, 4, and 5 from table B and match them up in table A where both entries 1 and 2 are the same. For example, if table A and table...
  3. L

    How can I find records with duplicate entries in their first two fields?

    Say I have a table with the following fields.. A | B | C | D | E | F What I want to do is the following.. Find and display all rows in which the fields A and B are the same. It dosent matter to me what entries are in C, D, E, and F. So if one entry was hoover | Frank | foo |...
  4. L

    Can I query the results of a query?

    Like to somehow take the results of one query, store them in a table, and then take another query to query those results? Or maybe ot store them in a table but somehow take results of query 1 and then run query 2 on them?
  5. L

    need to do a sum of values with out double summing the duplicates.. (I am stuck)

    need to do a sum of values with out double summing the duplicates.. (I am stuck) Example.. Table has 4 fields. Server name, file system, installed, used. There are duplicates in the server name field and the file system field. I want to sum up the total file system installed and used on...
Back
Top Bottom