Recent content by LordJezo

Okay, so the SELECT statement is considered the calculation: SELECT First([import_table].[server_name]) AS [server_name Field], First([import_table].[filesystem]) AS [filesystem Field], First([import_table].[filesystem_size]) AS [filesystem_size Field], First([import_table].[filesystem_used])...

More of an asking. Using what the first response said to try to figure out what it does. I have no idea how its only selecting distinct rows, only that it some how is.

So what it does.. if I have a bunch of duplicate entries in the selected fields, it will only return the first one of each set of duplicates? That's what it does when I run it anyway. To make it clearer.. I have a large table with many entries. It seems like the query is selecting only...

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

Is there any easy way to make an update query?

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

How do I get to the duplicate wizard? Help says: "In the Database window, click Queries under Objects, and then click New on the Database window toolbar." But I see nothing anywhere labeled "Objects"!

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

So simple! Thanks. I will go play with that now. Can I nest queries in each other?

Thanks I took that and did it, but I had to modify your suggestion just a tad.. I can't figure out how to get a second query to be based off a previous query. What I ended up doing was taking the distict statement that you posted and having that query be a "make table" query. Then I had a...

Because I need to filter the data from the table in one way, and then filter it again a second time. I figured that if I could store it in a table I could just write a second query to filter it again.

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?

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