Prev: Excel 2007 Themes change.
Next: How to avoid '*' being used as wildcard in SUMIF?
From: bmmulligan1 on 1 Feb 2010 12:20
I use MS Query in Excel often. I am trying, however, to change the Join and
am given 3 options when I double click on the join between two tables. When
I do that, the botton 2 options are grayed out (I can't create inner/outer
joins). WHy is that and how can I get them "un-grayed" so I can change the
join type?
From: Jim Thomlinson on 1 Feb 2010 14:22
MS query does not like outer joins. It will only allow 1 and it will also
complain if you have multiple tables where 1 is outer joined. I personally
use a VBA routine connecting via ODBC when the need arises. You need to be
able to write the SQL from scratch to do that... Not sure if this helps...
--
HTH...

Jim Thomlinson


"bmmulligan1" wrote:

> I use MS Query in Excel often. I am trying, however, to change the Join and
> am given 3 options when I double click on the join between two tables. When
> I do that, the botton 2 options are grayed out (I can't create inner/outer
> joins). WHy is that and how can I get them "un-grayed" so I can change the
> join type?
 | 
Pages: 1
Prev: Excel 2007 Themes change.
Next: How to avoid '*' being used as wildcard in SUMIF?