Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
CJ CJ is offline
external usenet poster
 
Posts: 102
Default Require help related to Excel Query outer join problem

Hello, I have two related tables (Foxpro) one is a BOM table, and the other
is a picking table. I cannot get the Joins dialog box to accept option 2 or
3, as they are greyed out. No matter what I try, these boxes are always
greyed out!!! @#@#***

As per Microsoft documentation I have selected only two tables. My query
should show all records in the bill of material table, and records of what
has/has not been picked, hence the outer join. But for what ever reason I
cannot get the joins box to accept option #2.

Perhaps I have an older version of MS Quey (Office 2003 Professinal) The
help on this subject is very poor, and confusing.

Any help would be greatly appreciated.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MS Query Outer join with three tables Jim Excel Discussion (Misc queries) 0 February 15th 07 10:52 PM
MS Query: Looking for a work-around to 2-table limits for outer jo Jim Excel Discussion (Misc queries) 0 December 27th 06 08:41 PM
external web query? (sites that require login) JustinB Excel Discussion (Misc queries) 1 May 28th 06 09:01 PM
Non-excel related problem about thumbnails conksu Excel Discussion (Misc queries) 2 April 27th 06 10:36 PM
New Router, Excel problem.. are they related! gracenote Excel Discussion (Misc queries) 2 July 13th 05 07:26 AM


All times are GMT +1. The time now is 09:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"