Re: Access reports or Word Document

Thanks for sharing your insight on this Chris,
I'll try and better describe what I'm attempting to accomplish with Access.
We are trying to automate a document that already exists in Word that we have
been producing manually. The document has the format of a header section
with two tables side by side in the same vertical position on the page for
the full lenght of the page (one on the left the other on the right). I'm
using one query (query A) to populate the header section and populate
portions of the "table" on the left side of the page. I'm using another
query (query B) to populate the main body of the report which has several
records and occurs on the right "table". I need the records to line up
vertically for the left and right tables. ie query A populates a record in
the left table then query B populates the first of several records in the
right table at the same vertical position and repeats until all records that
have same primary key of query A are retrieved. The difficulty comes in at
the multiple records that query B generates in comparison to query A. I've
tried to use mail merge in Word but the problem is having two queries to
populate the report/document. If it displays right the below is how I would
like the main body of the report to appear. A and B are the different
queries, spaces represent different columns/fields. The number of records
varies for B.

AAA AAA AA AAA BBBBB BBBBBBBB
BBBBB BBBBBBBB
BBBBB BBBBBBBB
BBBBB BBBBBBBB
AAA AAA AA AAA BBBBB BBBBBBBB
BBBBB BBBBBBBB

I hope the above is sufficiently clear to describe what I'm attempting,
Thanks for your help.

"chris.nebinger@xxxxxxxxx" wrote:

Paul,

No, you can not import a Word document into a Report.

As far as the subreport, maybe if you explained what you wanted to do,
we could give better advice. I generally try and stay away from
subreports if at all possible due to difficulties getting things lined
up.

I'll throw my $.02 into the pot.

Access has a great report writer. It's limited in output capability,
however. I've had clients who required Word versions because that's
how the report was circulated. I argued, but the client requirements
are what I went with.

Also, Access reports are "banded." For flexibility, Word often is
better. It is also easier to do complex formatting in Word. If it is
going to be a printed report, then Access wins hands down.

Access reports are very fast to create. I estimate 5 hours per report
when I am creating a budget. If Word (or Excel) is involved, I easily
triple my estimates.

Both items are tools in the toolbox. If you ask "Which is better, a
hammer or screwdriver?" the answer will depend on "Are you using nails
or screws?"


Chris Nebinger


Paul H wrote:
Larry,
Thanks for your advice and your comments about subreports. I will give this
a try and reply back if I can't figure it out. One more thing, is it
possible to "import" a Word document format into an Access report given that
the document format is relatively straight forward. I'd like to save some
formatting time if possible.

"Larry Linson" wrote:

"Paul H" wrote

> I'm new to the database world and I could
> use some advice as to which is better.
> Should I use Word mail merge to produce
> documents from data in Access or produce
> reports directly from Access.

I am sure that, in retrospect, you realize that there is no general answer
to this question. It's somewhat like asking, "Should I use a jet plane, a
truck, a car, or a bicycle to move my package from place to place?"

I've used Microsoft Access daily since 1993, created many database
applications for clients, and worked on many others. In none of those cases
did we have to use Word to produce documents instead of Access' Reports, but
most of those were "typical business database applications." There are
certainly cases where it can be beneficial to employ Word, either with mail
merge, or via COM automation, for particular purposes. If I were producing
"nicely formatted client letters," then mail merge might be the choice; if I
were producing brochures (intended to impress with fancy formatting) then
driving Word via COM automation might be appropriate; for useful business
reports, Access' Reports are often perfectly satisfactory.

> There are a couple of things
> I need to contend with first.

> I need to produce a report that uses multiple
> data sources (two or more queries) and puts
> them on a single page.

Access has a Subreport capability, so that you can embed Reports within a
Report. And, depending on how the information is related, you might be able
to join Tables or Queries so that only one Query produces the informaion you
want to Report. In general, I can say "this should not be a problem," but I
don't know the specific details.

> If I use Access does it have the formatting
> capability to reasonably reproduce the
> "look" of the documents we currently produce
> in Word.

Access' Reports are very good, very flexible, and arguably the best
reporting engine ever. But Word's 'purpose in life' is formatting text, and
its capabilities far exceed any reporting engine. And, of course, we have no
idea how much of the capability of Word you actually use in your documents,
so we couldn't possibly answer this question.

> We use Office 2000 software.

If you use the Access 2000 that is included in Office 2000 Professional, I
strongly suggest that you make certain you have applied all the Service
Packs and updates to both Access and the Jet database engine. I trust you
are aware that Access 2000 is "out of support," so full support is no longer
available from Microsoft, and you cannot even rely that security updates
will be available in the future.

Larry Linson
Microsoft Access MVP





.

Relevant Pages

  • Re: Report/Query not selecting specific records
    ... I don't care much about the formatting of a field in the underlying table. ... This is a saved query "qryIfta" This query is the record source for the ... report & the report only serves as a vehicle to display the results of the ... "Duane Hookom" wrote: ...
    (microsoft.public.access.reports)
  • Re: cycle thru recordset filed collection
    ... Seems to me it would be easier to use a query and populate a calculated field ... Dave Hargis, Microsoft Access MVP ... I have a report where I dynamically build the text to be displayed; ...
    (microsoft.public.access.formscoding)
  • Re: Simplest way to create a report to look like a mail merge document
    ... For simple mail merge letters without Word, consider the Query By Form ... You could also send the report to Word for further formatting. ... > called (c/w writing an appropriate data file). ...
    (microsoft.public.access.reports)
  • RE: Report/Query not selecting specific records
    ... formatting within a query. ... This is a saved query "qryIfta" This query is the record source for the ... report & the report only serves as a vehicle to display the results of the ... button sets the form's visible property to false and opens the report. ...
    (microsoft.public.access.reports)
  • Re: Access reports or Word Document
    ... Query A and Query B are related on the Primary ... create a report based on Query C. ... using one query to populate the header section and populate ... It is also easier to do complex formatting in Word. ...
    (microsoft.public.access.gettingstarted)