I've always been stumped by this:

I have 6 tables joined in SQL and I want to end up with an Excel shee
that has one row per user. Tables are mostly one to one but two aren't
Example is userdata.lastname userdata.firstame, userequip.equiplist (on
to many), sessions.sessiontitle, sessionformats.format, etc.

I want to have a row that has the sessiontitle in column A, th
presenter last name in B, first name in C (if there is more than on
presenter...not sure what to do) sessionformat in D etc. equipmen
would go across the columns (pencil, paper, blackboard)

If someone could explain the technique for this...I would be foreve
grateful

--
ovrdrv
-----------------------------------------------------------------------
ovrdrvn's Profile: http://www.excelforum.com/member.php...fo&userid=3357
View this thread: http://www.excelforum.com/showthread.php?threadid=53351