Reports in Access from A Repeating Table / Section or Master Detai

[RB Life]

Newbie, so pls excuse...
Have spent about 10 hours trying to figure this out. I have a repeating
section and I submit to a server. I use merge and datasheet view so I can
see ALL the data. I can link to Access just fine and all the data shows up,
but I have little boxes between the data that I would like to get rid of so I
can do things with the data.

I have a Product Spec Change form that I am developing, where a parent
product may have many child elements that need to change. Each child
elements has many attributes (QTY, Cost, Date to Change, etc.), that I want
to relate the the child element, and relate all children to the parent. When
I have several children elements, their data gets jumbled with what I guess
is some sort of delimiter.

I want my report to be a summary of ALL of my active spec changes (perhaps
300 at a time), and merging forms isn't feasible. A summary report that is
simple to create by the many people that need it (non Access and Info Path
types, like me) is necessary.

Making me crazy...Thanks in advance for your help!

 

[Clay Fox]

As you have seen merge is not a good solution for reporting and aggregating
most data.

In order to have reporting you need to store your data in a database and
then use Excel or SQL reporting services or a summary Infopath form to do
your analysis.

I would recommend the Database Accelerator Package from http://www.qdabra.com

It includes everything you need and I could show you some example if you
wanted.

--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com