HTML report and dynamically add records from a query

J

JLPerez

Is there a way to program a report using HTML or mail merge or whatever it is
more compatible with Access and fields from a query?. I have a pre-format
document (Word Doc) where I need to "insert" certain fields in a spredsheet
look design.Depending on a field, I would need to create a block of info with
this. An example:
The key field if type of document: there are 3 types. US, Foreign and Extra
1. the US group woulp print the following fields: Doc #, date, Author, and #
of pages
2. the Foreign group would need to print: Doc#, date, Author, # of pages and
language.
3. The Extra group would need to print only 3 fields: Doc #, Date, Comments.
All these groups would be printed in a table look alike format in the same
report sorted by the key field.....
Any ideas on how to approach this?
Thanks

PS. I tried to use "Access reporting" and don't seem to be able to capture
the data as i needed. Unless there is a way within the grouping in the report
where I could split the format using IF/Then condition within the Design
view" of the report..is it possible?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top