MS Access Query Issue

The query should look like this
SYS_NME, SYS_URL, TEST_BEGIN_DATE, TEST_END_DATE, SYS_DESC apear only
once.
The following record should apear as many time as they are in the table
for a particular SYS_NME
F.FINDG_STAT_DATE,
FS.FINDG_STAT, F.SMRY AS SMRY,
F.RSK_DESC AS RSK_DESC, F.RCMN AS RCMN,
F.FINDG_NO, FR.FINDG_RSK_LVL, F.CMNT,
F.FINDG_RSK_LVL_ID, F.FINDG_NME, F.PLCY1,
F.PLCY2, F.PLCY3, F.PLCY4, F.PLCY5, F.PLCY6,
F.PLCY7, F.PLCY8, F.PLCY9, F.NEW_CMNT,
F.URL1, F.URL2, F.URL3, F.URL4, F.URL5, F.URL6,
F.URL7, F.URL8, F.URL9

thanks

moe

Dear Moe:

I don't see where that would make any difference.

Tom Ellison


"FA" wrote in message
oups.com...
Tom have got my problem absulotely right and i also do understand what
you are trying to say.What if i dump the queries into a temp table and
then do the word merge with that temp table?? what do you think about
that ???

Dear Moe:

As I wrote befo

"Every row in the results of a query must contain the same set of columns."

Every row of the results will have every one of the columns you mention, or
none, or some, but it will have the columns you choose.

Tom Ellison


"FA" wrote in message
ups.com...
The query should look like this
SYS_NME, SYS_URL, TEST_BEGIN_DATE, TEST_END_DATE, SYS_DESC apear only
once.
The following record should apear as many time as they are in the table
for a particular SYS_NME
F.FINDG_STAT_DATE,
FS.FINDG_STAT, F.SMRY AS SMRY,
F.RSK_DESC AS RSK_DESC, F.RCMN AS RCMN,
F.FINDG_NO, FR.FINDG_RSK_LVL, F.CMNT,
F.FINDG_RSK_LVL_ID, F.FINDG_NME, F.PLCY1,
F.PLCY2, F.PLCY3, F.PLCY4, F.PLCY5, F.PLCY6,
F.PLCY7, F.PLCY8, F.PLCY9, F.NEW_CMNT,
F.URL1, F.URL2, F.URL3, F.URL4, F.URL5, F.URL6,
F.URL7, F.URL8, F.URL9

thanks

moe

Hi Tom
well seems like i dont have no choice but to get some help with MS Word
VBA programming. If you can kindly bring this issue to any of the WORD
MVP that you know, so that we can have some programmig in MS Word which
can result in showing the some fields just one in the MS word document.

I would really really appreciate your help Tom.

Dear FA:

I believe you should post the question in a Word newsgroup. If there are
additional questions about what you want, you would be the one to answer
them.

Tom Ellison


"FA" wrote in message
ups.com...
Hi Tom
well seems like i dont have no choice but to get some help with MS Word
VBA programming. If you can kindly bring this issue to any of the WORD
MVP that you know, so that we can have some programmig in MS Word which
can result in showing the some fields just one in the MS word document.

I would really really appreciate your help Tom.

yes but i thought you offered this in the early post. I will be
answering all the questions and i preffered to continue this post since
we have already discussed alot of stuff and came to the conclusion that
we need to do this in MS Word. I really appreciate your help Tom

Take care
Moe

Dear Moe:

What I said was:

"If you get a Word MVP involved in one of their NGs, let me know, and I can
join the discussion there to iron
out the details."

After you start a thread there, let me know if my involvement would be
useful.

Tom Ellison


"FA" wrote in message
oups.com...
yes but i thought you offered this in the early post. I will be
answering all the questions and i preffered to continue this post since
we have already discussed alot of stuff and came to the conclusion that
we need to do this in MS Word. I really appreciate your help Tom

Take care
Moe

I have posted my issue on "comp.os.ms-w...ord-proc " with the title
"Mail Merge from MS Acces to MS Word ". Have not got any reply yet
from anyone.

Thanks