Do 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:
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 well 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.
