Very new to report but need to try something, sorry

[philomaher]

Hi all,

I initially posted this on the Word Newsgroup and was pointed to try
using Reports within Access, I really have no clue about Reports other
than the most basic. Is there someone who could help me out with the
problem as described below?

Thanks in advance

I hope the title has drawn in the right people. I have a number of
tables within access and would like to create word documents from
these, that I can do, except in this case there are a couple of
complications which I will do my best to describe:


I wish to create 700 documents from my data which will be about 1400
rows in access. The documents are broken down as follows:


<<ID>> <<applicant name>> <<Institution Name>>
<<Title>>
Abstract
<<Abstract>>
<<Review #1>>
<<Reviewer #1 Name>> <<Rating Text #1>>
<<Review #2>>
<<Reviewer #2 Name>> <<Rating Text #2>>


There will be a minimum number of 2 reviews per document (ID) but I
can't repeat the document information (lines 1 to 4)

 

[Marshall Barton]

I initially posted this on the Word Newsgroup and was pointed to try
using Reports within Access, I really have no clue about Reports other
than the most basic. Is there someone who could help me out with the
problem as described below?

I hope the title has drawn in the right people. I have a number of
tables within access and would like to create word documents from
these, that I can do, except in this case there are a couple of
complications which I will do my best to describe:


I wish to create 700 documents from my data which will be about 1400
rows in access. The documents are broken down as follows:

<<ID>> <<applicant name>> <<Institution Name>>
<<Title>>
Abstract
<<Abstract>>
<<Review #1>>
<<Reviewer #1 Name>> <<Rating Text #1>>
<<Review #2>>
<<Reviewer #2 Name>> <<Rating Text #2>>


There will be a minimum number of 2 reviews per document (ID) but I
can't repeat the document information (lines 1 to 4)

Create a group with header on the ID field and place the
controls for first four lines in the group header section.
Use the Sorting and Grouping window available on the View
menu when the report is open in design view.

 

[Duane Hookom]

There is a generic concatenate function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane that you
might be able to use. I would create a query with the generic function that
would create a string of the Review information with tabs and carriage
returns embedded. I almost always use the query to create a Word Merge file.
Your main Word document can use a merge field that properly formats the
tab/carriage return string.

If you need more assistance, come back with information about your
significant tables and fields such as names and data types.

 

[philomaher]

Thanks Duane and Marsh

I will try both your suggestions and put in my feedback

 

[Duane Hookom]

I am a little surprised the Word people didn't explain the NEXT RECORD
functionality within Word merging. I thought this would work for you.

 

[philomaher]

Thanks again

I ended up using the report grouping and got what I needed although I
will try your solution Duane when the work dies down a bit