Do you
have the correct link between a report and a subreport (child field and master
field, in the Data page of the subreport's Properties), or between the key
fields in the tables in the query?
Tobi
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Trent Johnsey
Sent: Monday, January 09, 2006 10:40 PM
To: [email protected]
Subject: Re: [AccessDevelopers] Help with ReportDo you want all 7 matching records? If not, how many do you want? I am suggesting you create a subquery and eliminate the dups by elimination or a summary query(totals query).
The other thought is to hide duplicate records in the report detail section.
TJ
bassfolks <[EMAIL PROTECTED]> wrote:I'm sure this is simple stuff for most of you but I'm lost. I'm trying
to create a report from a query of related tables and it's entirely
possible that my query is structured wrong. In any event, when I try
to report the results, I cannot keep the information from duplicating.
In other words, if I have seven records relating to one ID, that entire
series repeats seven times in the report.
If anyone can help me straighten this mess out, I would be grateful!
Thanks!
Debbie
Yahoo! Photos – Showcase holiday pictures in hardcover
Photo Books. You design it and we’ll bind it!
Please zip all files prior to uploading to Files section.
SPONSORED LINKS
Microsoft access developer Microsoft access help Microsoft access database Microsoft access training Microsoft access training course Microsoft access programming
YAHOO! GROUPS LINKS
- Visit your group "AccessDevelopers" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
