Duplicates on Report

[ladybug via AccessMonster.com]

I am having a repeating issue with a report of mine. I am going to try to
explain and hope someone out there understands me!

Table 1 Table 2
AutoNumber AutoNumber
Issue #

(Table 2: An Autonumber can have multiple Issue #'s and an Issue # can be in
a single Autonumber multiple times)

I am trying to create a report where the query prompts the user for an Issue
#. The report returns with:

Issue #
Autonumber
Then lists all other issues that are corresponding with this Autonumber.

The problem I am running across at this point is the list of Corresponding
Issue #'s is repeating if the Issue # is represented multiple times in one
Autonumber.

If this makes any sense at all, any assistance would be greatly appreciated!!!
!!!

 

[kingston via AccessMonster.com]

I'm not positive I understand but you can set your query to return a set of
results only once by changing the query's Unique Values setting to Yes. Do
this in design view and in the query's properties window (right click on the
design background and select Properties..."). HTH

 

[ladybug via AccessMonster.com]

No luck. Thank you for trying!

I'm not positive I understand but you can set your query to return a set of
results only once by changing the query's Unique Values setting to Yes. Do
this in design view and in the query's properties window (right click on the
design background and select Properties..."). HTH

I am having a repeating issue with a report of mine. I am going to try to
explain and hope someone out there understands me!

[quoted text clipped - 19 lines]

If this makes any sense at all, any assistance would be greatly appreciated!!!
!!!