Outer join not returning null values.

[Count Duckula]

Hi,



I've got a query that's using 2 tables with an outer join. However, for some reason I cannot see all of the results from the primary table, it is only returning values where there are matching records.

Any ideas why?

Thanks.

[RuralGuy]

Post the SQL View and maybe someone will see something that can help.

[Count Duckula]

Post the SQL View and maybe someone will see something that can help.

I looked at the SQL and it was actually an inner join. To be honest I'd followed the Access online help and it had said that for an outer join to select the second option in join type. This doesn't appear to be the case. Anyway I've fixed now, thanks for your help.

[RuralGuy]

Great! Thanks for posting back with your success and solution. Another mystery solved.