Access Question

[Dirk Diggler]

I make a query that combines two tables. (just a select query)

For simplicity, let's say that it only has two fields, each coming from a different table.

I now want to make another query based on this first one, where I want to select all the records where the two fields are equal. (I know I could have done this in the first one, but my situation is more complex)

In design view it looks like this:

Field: Table1.Field1
Table: Query1
Criteria: [Query1]![Table2.field1]

When I try to run it, I get the following error message:

"Invalid bracketing of name '[Query1]![Table2.field1]'"

Does anyone know what my problem is? I really don't understand as I wrote my criteria using the "Build..." function.

Thanks to anyone who can help.

[Dirk Diggler]

Nevermind, I found my problem.

It is because my two fields had the same name.

If I rename them differently in my first query, I won't have that problem.

Thanks anyways.