T
Tom
All,
Is there a straightforward way to use the same report to produce
output from multiple instances of linked Excel tables having the same
data structure, and pick the driving table at report runtime? I
realize this would be a simple task if all the data were in one master
table, but I don't know if pulling the data into one normalized table
is feasible given the intended user who has almost no experience with
Access.
The goal is to provide my customer with an easy way to communicate
delivery requirements for each contract modification while still
allowing him to use his legacy Excel template required by his
enterprise. I get squeamish thinking about trying to explain to him
how to append records, delete records, etc., and thought I'd try and
give him the best of both worlds.
I have already duplicated his report format in Access and created a
table to hold report setup options by contract modification number.
Now I'd like to capture each version of the schedule (controlled by
modification number) and pick the driving data at report runtime. I'm
envisioning holding report options in a MODS table and pulling the
data from multiple linked Excel files containing the schedule records.
The Excel files would be named using the modification number
(MOD0001.xls, MOD0002.xls, MOD0003.xls, etc.) A MODS table within
Access would contain records keying off the MOD_NUMBER field with
everything needed to populate the report headers and footers.
How do I tell Access which of the myriad linked Excel files is the
right one at report runtime?
Any ideas?
Thanks,
Tom
Is there a straightforward way to use the same report to produce
output from multiple instances of linked Excel tables having the same
data structure, and pick the driving table at report runtime? I
realize this would be a simple task if all the data were in one master
table, but I don't know if pulling the data into one normalized table
is feasible given the intended user who has almost no experience with
Access.
The goal is to provide my customer with an easy way to communicate
delivery requirements for each contract modification while still
allowing him to use his legacy Excel template required by his
enterprise. I get squeamish thinking about trying to explain to him
how to append records, delete records, etc., and thought I'd try and
give him the best of both worlds.
I have already duplicated his report format in Access and created a
table to hold report setup options by contract modification number.
Now I'd like to capture each version of the schedule (controlled by
modification number) and pick the driving data at report runtime. I'm
envisioning holding report options in a MODS table and pulling the
data from multiple linked Excel files containing the schedule records.
The Excel files would be named using the modification number
(MOD0001.xls, MOD0002.xls, MOD0003.xls, etc.) A MODS table within
Access would contain records keying off the MOD_NUMBER field with
everything needed to populate the report headers and footers.
How do I tell Access which of the myriad linked Excel files is the
right one at report runtime?
Any ideas?
Thanks,
Tom