Access 2003 - printing question

Latest post 09-14-2006 6:09 AM by jazambos. 2 replies.

Access 2003 - printing question

09-13-2006 7:18 AM

Hi, I need help trying to figure out how to print subdatasheets in Access. We currently use Access to track donor giving, and each donor's giving history is contained in a sub data sheet. I have expanded all the sub data sheets in the table and tried to print but the giving history doesn't show up.

Any ideas on how to print the sub data sheets?

Thanks,

Erik Torch
etorch@damianocenter.org

Damiano Center
Duluth, MN

RE: Access 2003 - printing question

09-13-2006 8:34 AM

The typical access way to do this would be to create a subreport of the detail you want to show in the sub datasheet, then create a main report with the info on the client or main subject, and link a key from the client to the sub-data when you create the subreport.

You can probably google on subreport for more info.

Bob

RE: Access 2003 - printing question

09-14-2006 6:09 AM

The subdata should be held in another table.

You can create a query or report with the needed information. I find it easier to create a query and then build a report from the query.

If you go to microsoft.com you can get a lot of help with Access in the knowledge base.