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?
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?