By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,728 Members | 1,081 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,728 IT Pros & Developers. It's quick & easy.

Subreport question

P: n/a
I'm in a sad state, not knowing anyone who knows more than the little I do
about Access, so I'm having to learn it all from a book. Sometimes I just
can't find what I need to know.

People in my database may have made multiple payments recorded in the system
in a table linked to the Person table by Person#. In addition to other
information about the person in the report I'm producing, I need a list of
all of their payments. I assume that requires a subreport for payments, but
how do I get the subreport to show payments from just the specific person?
At the moment, my report shows each person's record properly, but beneath
each person's data is the entire subreport of payments, repeated identically
for each person. How do I do the filtering (by Person#) and where so that
the subreport doesn't show my whole database?

Thanks, David

I'm also new at munging my email address. I hope I'm doing it okay without
making it impossible to contact me. Of course I'll check here for replies.
Correct email is thomson.dc.2424 at mindspring.com


Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
Use the LinkMasterFields and LinkChildFields of the Subreport Control,
specifying the field that identifies the person in each the Person and
Payments records. That's the great strength of the Subform/Subreport
control -- that it can do what you describe with no code, no macros, just
property settings...

Larry Linson
Microsoft Access MVP

"David" <thomson.dc.2424(dele)@mindspring.TYPE.COM.HERE> wrote in message
news:8m****************@newsread1.news.atl.earthli nk.net...
I'm in a sad state, not knowing anyone who knows more than the little I do
about Access, so I'm having to learn it all from a book. Sometimes I just
can't find what I need to know.

People in my database may have made multiple payments recorded in the system in a table linked to the Person table by Person#. In addition to other
information about the person in the report I'm producing, I need a list of
all of their payments. I assume that requires a subreport for payments, but how do I get the subreport to show payments from just the specific person?
At the moment, my report shows each person's record properly, but beneath
each person's data is the entire subreport of payments, repeated identically for each person. How do I do the filtering (by Person#) and where so that
the subreport doesn't show my whole database?

Thanks, David

I'm also new at munging my email address. I hope I'm doing it okay without
making it impossible to contact me. Of course I'll check here for replies.
Correct email is thomson.dc.2424 at mindspring.com

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.