Ah hah! When you guys told me my query was doing what I had told it to, you knocked a wall out of my head! I have only been using Access for 4 months, & I think I get a bit "Query-Happy". After reading the responses, I realized that I needed to import all 30 of my spreadsheets (the 30 tables) into one table using the "append" option while importing, and then do a query one the one table to sort the documents to group them...

Ultimately, what I want to do is to see all of the amounts in each table that are tied to the particular document, and to have that in one place. Should I be doing this diffently? Sounds like I probably should. What's the best way? Also, ultimately I will have about 30 tables from different accounts, if that matters.

I want to run a query that will give me the amounts from two accounts with the same document name. I have a table created for each account (tables are named "171100" & "173100"), and created an Inner join between the tables on the column "Document" to run a query, but I get duplicate entries on the tables' Amount Column. The query looks like this in Datasheet View:

...