MS Query - Joining two tables....

[Marc T]

Hi all,

I'm nearly pulling out what's left of my hair at this!

I have two tables in MS Query, one which I need to display all data from,
and the other from which I only need to display data if it relates to the
first table... basically an outer join? Trouble is, the link between the two
tables is a set of three fields; Requisition Number, Line Number, Release
Number. I can't set more than one outer join. What I'm trying to get is a
list of requisitions from first table, with order info (if available) from
second.

I've tried a whole outer join, but the fact that the query takes a parameter
completely throws this out.

Does anyone have any advice on what to try next?

Cheers,
Marc

 

[Jim Thomlinson]

MS Query is a little lacking for anything but the simplest of queries. From
what you have described you might need to look into a custom VBA solution
using ADODB Recordset. This leverages your ODBC driver to execute the query.
The only other option I can think of would be to place Access between Excel
and your final database. Create a your sophisticated query in Access and use
MS Query to link to the Accesss query.