Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / January 2008

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
RB Life - 05 Jan 2008 16:54 GMT
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 - 07 Jan 2008 17:10 GMT
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.

Signature

Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

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

> Newbie, so pls excuse...
> Have spent about 10 hours trying to figure this out.  I have a repeating
[quoted text clipped - 16 lines]
>
> Making me crazy...Thanks in advance for your help!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.