Search results

Nice one, Paul! Many thanks for your quick reply! I got it to work based on your shell--amazing!! I never knew about that UNION ALL function... thanks again. SELECT tblConnection.Place1, tblPlace.Type, tblPlace.Name FROM tblPlace INNER JOIN tblConnection ON tblPlace.Place_ID =...

I'm using Access 2000. I have 2 tables in my query: tblPlace and tblConnection. Using a form and the Connection table I can link 2 places together from the Place table and present it in a query; for example: SELECT tblPlace.Place_ID, tblPlace.Name, tblPlace_1.Place_ID, tblPlace_1.Name FROM...