It is possible to output the results of an Access report into a text field for later retrieval?
The concept is simple. I am creating automatic letters using Access reports and I would like to store the results in a SQL Server table for later retrieval and proof of generation.
The letters have 20 or so optional paragraphs, each with their own variable information, so storing the parameters for creating the reports may prove to be very complex.
I would prefer not to use any third party tools (especially one that costs!!).
TIA
Marcus.
The concept is simple. I am creating automatic letters using Access reports and I would like to store the results in a SQL Server table for later retrieval and proof of generation.
The letters have 20 or so optional paragraphs, each with their own variable information, so storing the parameters for creating the reports may prove to be very complex.
I would prefer not to use any third party tools (especially one that costs!!).
TIA
Marcus.
