It looks like I finally resolved the problem. Basically, I dragged tbl_EQ onto the editor two times.

SELECT q.LastName, q.FirstName, r.LastName, r.FirstName

FROM (tblComps AS c INNER JOIN tbl_EQ AS...

Hmm, unfortunately the above query statement gives me syntax errors also.

I'll close this thread and post to the Access forum.

Jeff, I read your "Emily Post" etiquette guide on how to properly post schemas, etc. Seriously, it all looks good but I'm doing these tables in Access 2003 (should I...

Rob, I receive the same error message without the comma.

ColdCoffee (5/3/2010)

---

Quite possible, buddy.. but you will have to tell us atleast the description of the house; we ourselves will find out the address and the fastest way getting there.....

Rob Schripsema (5/3/2010)

---

reg 18234 (5/3/2010)

---

The SQL statement below returns what I want for the first few columns of the row (for Comp1), but I don't know how to pick up...