database duplice

[Dennis Burgess]

I have Invoice, deal fields

I want to have a listing of invoices that have duplicate lines, but only if
the other entry's deal number is NOT the same.

So I would only get back a single invoice number that has multiple deal
numbers in the database?

I can get it where I get all the dups on invocie, but don't know how to
filter it out IF the deal number is the same. So if there is just one deal
number, but 5 lines of invoices that referance that deal number, thats fine,
but I don't want to display that. I want to know the ones that have 5 lines
and 3 of them are a differant deal number. In this case, I would have 2
deal numbers and the invoice number would be the same.

Any thoughts?

Dennis

 

[Jeff Boyce]

Dennis

I'm having trouble visualizing your data from your description.

Are you saying you have records that hold invoice numbers and "deal
numbers"?

And that you want to see unique combinations of these two?

If so, create a query, add these two fields, then use the query's Properties
to set Unique Values to Yes.