Re: not all member in the same page

OK thank you Allen, you are right, that main report should have recourd
source from address table, not query, because in my address query it has
address ID, so it shows again in the subreport.

Thanks very much it is ok now.

--
H. Frank Situmorang


"Allen Browne" wrote:

Frank I can't see your data structure, so I can't see why they are repeated
in the subreport.

I'm guessing that the RecordSource for the subreport must be a query that is
not set up correctly, so the query repeats the people in the household, and
so the subreport just does what the query says.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Frank Situmorang" <hfsitumo2001@xxxxxxxxx> wrote in message
news:B8BD6099-7B63-45F3-A03C-3DA61140A56F@xxxxxxxxxxxxxxxx
I have checked that Allen, it is ok, but the case now it is not mixed with
the other member of the household, but it repeats the same member.

For example in houshold P ( Main report)
There are 2 members ( in the subreport)
Mr. A
Mrs. B.

But it shows in the report view:
Mr. A
Mrs.B
Mr. A
Mrs. B

Why it is repeated 2 times in the page.
The other problem I want it that if more than 4 members ( because it fits
4
member in one page, it goes to the next page, and the closing sentence (
which is page footer) will go in the next page, since in Indoensia could
be a
lot of members in one household, we want it go to next page if more than 8
and so forth...

Thanks for your help Allen
--
H. Frank Situmorang


"Allen Browne" wrote:

So you have set up the tables, with the relationships, and entered data
so
you know who belongs to which household, but you are getting way too many
people showing up in your subreport (not just the members of the
household
in the main report.)

If that's what is going on, it sounds like the linkage between main
report
and subreport is not set up correctly. So:

1. Open the main report in design view.

2. Right-click the edge of the subreport control, and choose Properties.

3. On the Data tab of the Properties box, set LinkMasterFields and
LinkChildFields.

LinkMasterFields should contain the name of the control in the main
report
that identifies the household. LinkChildFields should contain the name of
the matching field in the subreport.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Frank Situmorang" <hfsitumo2001@xxxxxxxxx> wrote in message
news:3BB47343-C6BE-437A-BD06-4A5426E25F07@xxxxxxxxxxxxxxxx
thanks allen for your quick response and the website you gave me. I
have
checked the website and it is similar with address sample of MS
database.

I have successfully made it in the form using tab of course with child
and
master link fields.

My problem, I want to make it in the report, the member tab is to be a
subreport in the report, it can shows up, but the problem is that
members
in
the subreport are not from the same address/household

I appreciate your help.

--
H. Frank Situmorang


"Allen Browne" wrote:

Frank, this is quite a big question.

Here's a very flexible solution that lets you choose the people to
include
in a mailing, as either a household or as individuals:
People in households and companies - Modelling human relationships
at:
http://allenbrowne.com/AppHuman.html

That may be more than what you need, but you have been asking lots of
questions, so I think you are ready to consider a relational approach
like
this.

"Frank Situmorang" <hfsitumo2001@xxxxxxxxx> wrote in message
news:9F6FCB1B-BFEB-4E0C-B0CA-40663F056B2D@xxxxxxxxxxxxxxxx
Hello,

I have resolved the problem in my previous thread, and now my
problem
that
the member of the family is not gruop into 1 page, but combined with
other
family member in another addresss/household

What I want is this serves as a letter to update each household
data.
What
goes wrong while it works in the form using 1st tab as household
data
and
members in the 2nd tab.




.

Relevant Pages

  • Re: not all member in the same page
    ... the other member of the household, but it repeats the same member. ... For example in houshold P (Main report) ... There are 2 members (in the subreport) ...
    (microsoft.public.access.reports)
  • Re: not all member in the same page
    ... I'm guessing that the RecordSource for the subreport must be a query that is not set up correctly, so the query repeats the people in the household, and so the subreport just does what the query says. ... For example in houshold P (Main report) ... The other problem I want it that if more than 4 members (because it fits 4 ...
    (microsoft.public.access.reports)
  • Re: not all member in the same page
    ... So you have set up the tables, with the relationships, and entered data so you know who belongs to which household, but you are getting way too many people showing up in your subreport (not just the members of the household in the main report.) ... If that's what is going on, it sounds like the linkage between main report and subreport is not set up correctly. ...
    (microsoft.public.access.reports)
  • Re: query design issue
    ... Create a main report of just each unique Provider. ... a multi-column subreport that is based on the Provider and Member records. ... Set the subreport to display across then down. ...
    (microsoft.public.access.queries)
  • Household vs Member
    ... I have a member table and a household table. ... There can be multiple members in ... On a report, I am trying to list members in Asc order by ...
    (microsoft.public.access.reports)