Solution needed

[prif]

Hello guys,

Although I have been consulting this forum for quite awhile, this is my first post (first time I could not find my solution).

So, I have the following problems. I need to create a database for a specific kind of data. This will be used to create daily reports with certain data. Everyday someone collects a specific kind of data put it together and send it via mail. As the data regarding the data (heading, region, etc) in the report has to be captured in order to do the respective statistical analyses I am trying to automate this process. This report has to be stored in word and pdf. and send by email daily, grouping the info by let's say Col1 and then Col2.

Is there any way of creating a template in word that pulls this data to access? It seems more feasible to me the other way around.

I am not an English native speaker and I am not naturally a good speaker, so let me know in case this text does not make any sense and I will try to brush it up.

Thank you in advance.

 

[GaryPanic]

First thing - Are you sure it has to be Word
Spreadsheet (Excel) would be the logical choice for this

Word is not a "data" friendly place to be in - - fine for pretty layout reports
you can then export in to a pre-defined word document - loads of examples of this all over the place
and do what you will with it - but once in Word - you lose all data capture/functionality- becomes a document that has measurable value ( in regards to data)

 

[prif]

Thanks for your answer, GaryPanic.

Word is just for the final report. It can be a word with data pulled out of Access. The data is mainly formed of text cells.

The only problem I see is that the Word doc must be in the following format:

Title

Col1 X
Col 2 X
Col 2 Y
...

Col 1 Y
Col 2 X
Col 2 Y
...

 

[prif]

Basically the question now is how can I extract the info from access to word in a way that I can group them and apply a template on it.

Let's say:
Heading1=Col1 X
Heading2=Col2 X
Normal text = Col 3 X

Heading1=Col1 Y
Heading2=Col2 Y
Normal text = Col 3 Y
Heading2=Col 2 Z
Normal text = Col 3 Z
(.....)

Can anyone help me?

 

[arnelgp]

create your Report in Access and use DoCmd.Output..., to output your report as RTF or PDF.