Duplicates on Report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ladybug - 16 Nov 2006 18:48 GMT

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!!!
!!!

Reply to this Message

kingston - 16 Nov 2006 19:43 GMT

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!!!
>!!!

Reply to this Message

ladybug - 16 Nov 2006 20:08 GMT

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
[quoted text clipped - 6 lines]
>>If this makes any sense at all, any assistance would be greatly appreciated!!!
>>!!!

Reply to this Message