Access Queries aren't showing up

My Access queries (Access 7) aren't showing up at all. But if I cut and paste the SQL for one of them into the Query Builder, it validates and runs:

SELECT tblContacts.Last, tblContacts.First, tblEmailType.[Email Type], tblEmail.Email, tblEmail.Notes
FROM tblEmailType INNER JOIN (tblContacts INNER JOIN tblEmail ON tblContacts.ID = tblEmail.ID) ON tblEmailType.[Email Type] = tblEmail.[Email Type]
ORDER BY tblContacts.Last, tblContacts.First;
1 person has
this problem
+1
Reply