Taking out info from 100,000 records and comparing to smaller table?

  • Thread starter Thread starter scott
  • Start date Start date
S

scott

I have 2 tables.

1. Has 136,000 customer records. This is what our customer
has.
2. Has about 6000 records which we pull in our system

They both have Cost Centers so I tried making a criteria
by Cost Center....I linked them up but I am getting TONS
OF DUPLICATES of the 6000 records.

An example is this.
We show jane doe pager # 518 666 6666 cost center 1
john doe pager # 617 215 4444 cost center 1

There can be 1000's of people in cost center 1 but what
its doing is this

jane doe pager # 518 666 6666 cost center 1
jane doe pager # 518 666 6666 cost center 1
jane doe pager # 518 666 6666 cost center 1
jane doe pager # 518 666 6666 cost center 1
john doe pager # 617 215 4444 cost center 1
john doe pager # 617 215 4444 cost center 1
john doe pager # 617 215 4444 cost center 1

thousands of times.

Instead of
jane doe pager # 518 666 6666 cost center 1
john doe pager # 617 215 4444 cost center 1

How do I get it to JUST show this record once?

Thanks
Scott
 
How do I get it to JUST show this record once?
Click to expand...

Open the Query in design view; view its Properties (with the View menu
option or by right mouseclicking in the background of the table
window). Set the "Unique Values" property to True.
 
Thank you for this info..If I do this will the cost center
only bring back a cost center once?

I could have 50 different people in the same cost center
and I want to bring them all back once.

the cost center will have to be listed more than once.

Thanks
Scott
 
Thank you for this info..If I do this will the cost center
only bring back a cost center once?

I could have 50 different people in the same cost center
and I want to bring them all back once.

the cost center will have to be listed more than once.

Thanks
Scott
 
Thank you for this info..If I do this will the cost center
only bring back a cost center once?
Click to expand...

It will show only one of each set of records which are duplicates in
all of the selected fields. That is, if you show the person's name,
pager number, and cost center, you'll see one row for each unique
combination of those three fields.
 
Back
Top