P
PZ Straube
Please forgive some basic questions but I'd like to see if I can use Access
2003 for some reports I currently do in Excel and Word 2003.
One of my client reports in Excel consists of data queried from Access and
has about 200 columns of data for each time period. There are 16 quarters of
data (roughly 3,200 cells) which is then further multiplied by 5-20 products
grouped on the same tab depending on the client. It is easy to do in Excel
but I prefer the report capabilities of Access where I wouldn't have to copy
formulas down for each quarter, each product, and for each client (with the
errors all that copying might lead to). My concern centers around
limitations of Access regarding the number of data fields in a query and
subsequently a report. Is it possible for me to create queries with
calculated fields that in the final report might number 60,000+ individual
pieces of data spread accoess multiple pages both horizontally and vertically?
In another client report, I have about 200 charts set up in Excel spread
across four different chart types (50 different products). These charts are
linked to a report inside Word 2003 that contains the main report. This
report is mostly generated automatically not only with the charts but also
text inside calculated cells in Excel that change with the underlying client
data. These XY/Scatter charts and other combo charts are fairly complicated
(to me) and I have written macros to modify chart parameters such as scale,
fill-in patterns for stacked boxes, data labels, font colors, etc. subject to
the underlying data. My impression of Access is that the charting
capabilities are not strong. I need to determine whether Access can do these
charts inside a report - perhaps through an add-in? Or, I didn't know if
there was some way for Access to interact with Excel to create the charts
then use them within the Access report.
Thanks for your help!
2003 for some reports I currently do in Excel and Word 2003.
One of my client reports in Excel consists of data queried from Access and
has about 200 columns of data for each time period. There are 16 quarters of
data (roughly 3,200 cells) which is then further multiplied by 5-20 products
grouped on the same tab depending on the client. It is easy to do in Excel
but I prefer the report capabilities of Access where I wouldn't have to copy
formulas down for each quarter, each product, and for each client (with the
errors all that copying might lead to). My concern centers around
limitations of Access regarding the number of data fields in a query and
subsequently a report. Is it possible for me to create queries with
calculated fields that in the final report might number 60,000+ individual
pieces of data spread accoess multiple pages both horizontally and vertically?
In another client report, I have about 200 charts set up in Excel spread
across four different chart types (50 different products). These charts are
linked to a report inside Word 2003 that contains the main report. This
report is mostly generated automatically not only with the charts but also
text inside calculated cells in Excel that change with the underlying client
data. These XY/Scatter charts and other combo charts are fairly complicated
(to me) and I have written macros to modify chart parameters such as scale,
fill-in patterns for stacked boxes, data labels, font colors, etc. subject to
the underlying data. My impression of Access is that the charting
capabilities are not strong. I need to determine whether Access can do these
charts inside a report - perhaps through an add-in? Or, I didn't know if
there was some way for Access to interact with Excel to create the charts
then use them within the Access report.
Thanks for your help!