data processing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am new to using hte report function in access and was wondering how to
write a report in a text format. Similar to mailmerge in Word, but word
limits the functions i want to use becasuse i need to bring data from several
different tables. Is it possible to do this with access?

thanks
 
"Russ" wrote
I am new to using hte report function in
access and was wondering how to write
a report in a text format. Similar to mail-
merge in Word, but word limits the func-
tions i want to use becasuse i need to bring
data from several different tables. Is it
possible to do this with access?
Click to expand...

It is possible to use data from multiple Tables in an Access Report.

Access Reports themselves might be considered "similar to mailmerge in
Word", but they are not identical to that. You'd have to clarify what you
mean before anyone could answer.

There are multiple ways to use data from multiple tables in Access Reports.
One of those ways might accomplish what you want to do. But we'd really have
to have some clarification as to what you are trying to accomplish to offer
any useful suggestions.

Larry Linson
Microsoft Access MVP
 
Larry,
Thank you. What I am trying to do is take data from different tables and
write a letter. For example, I have teh clients name, age, and address in
Table A. Table B has information on there previous orders. Table C has
information regarding orders from the sales department. Table D has
information about orders from teh service department, and so on. I have
several tables all related in this way. Obviously, not all clients will have
records in each table.

I want to be able to write a letter to the client using a report that
summarizes our services. It can be a form letter. But some of the reports
will need to have additonal sections, ie another paragraph if the client had
previous orders. The report also has to be like a Word document in that it
will look like a normal letter, be gramatically correct, etc.

Thank you for your help

Russ
 
Back
Top