Wrox Programmer Forums
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old October 26th, 2003, 05:24 PM
Registered User
Join Date: Oct 2003
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to mhosneddine
Default Subreports in Access 2002

i have an unboud report containg more than one subreport, each bound to a certain query, all to the same table. I want to ask whether there is a command I can apply so that i can open the main report(the one containg the subreports) specifying different "where clauses" for each of these subreports.

 I hope you would get what I am trying to say.

thanks for whomever tries to help

Old October 26th, 2003, 08:55 PM
sal sal is offline
Friend of Wrox
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts

What is the retation between one subreport to the other?
Would it not be simpler to create a main report that is bound to a table/query, and then insert subreports that can related to the main report?

This would make the where clauses easier to pull any data you need.


Similar Threads
Thread Thread Starter Forum Replies Last Post
Upgrading from Access 2002 to Access 2003 lryckman Access 1 July 16th, 2006 01:46 AM
Access 2002 Chapter 5 JEHalm BOOK: Beginning Access VBA 0 January 11th, 2006 12:47 PM
Autonumber on Access 2002 pdunning Access 1 August 23rd, 2004 10:33 AM
Pivot tables in Access 2002 clickco Access VBA 1 June 3rd, 2004 02:25 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.