Linked Subreports Repeating

L

LarryP

Access XP/Windows 2000. Have a report that consists basically of two
subforms. Each subform shows similar-but-not-exactly-matching data from a
different source table/query. Sometimes, the match will show several records
from Source A and several from Source B that satisfy my partial-match
criteria, which is fine.

HOWEVER, the two subreports then REPEAT as many times as there are possible
hits in Source A, so if for example I have four Source A records and four
Source B records that approximately match, the two subforms repeat four
times.

I've played around with the grouping and child/master linking every way I
can think of but haven't been able to prevent the repetitious display.
Anyone have an idea?
 
M

Marshall Barton

LarryP said:
Access XP/Windows 2000. Have a report that consists basically of two
subforms. Each subform shows similar-but-not-exactly-matching data from a
different source table/query. Sometimes, the match will show several records
from Source A and several from Source B that satisfy my partial-match
criteria, which is fine.

HOWEVER, the two subreports then REPEAT as many times as there are possible
hits in Source A, so if for example I have four Source A records and four
Source B records that approximately match, the two subforms repeat four
times.

I've played around with the grouping and child/master linking every way I
can think of but haven't been able to prevent the repetitious display.
Click to expand...


This is normally caused by your main report having that many
detail records in its record source table/query. You should
change the main report's record source either to nothing or
to a query that does not include the details from either
SourceA or SourceB.
 
L

LarryP

I'll try that -- certainly seems logical...no doubt why I didn't think of it!
Thanks.
 
Top