View Full Version : Query wizard


croy
12-10-2001, 06:53 PM
I have a query that i want to turn into Outer/inner join, instaed of Ansi.
how can Access do that for me?

Pat Hartman
12-11-2001, 07:32 PM
I'm not sure that I understand the question. When you build a query using the design view in Access, you select a field in one table and drag it to a field in another table to specify a join. The default join type is Inner. To change the join type to Left or Right outer, right click on the center of the join line to bring up the join type dialog box. If the properties box comes up instead, close it and try clicking again. You need to be pointing to the center of the line to get the correct dialog box up.