Need help Getting Unique Records

[Max1mum2]

I am trying to Create a Customer Info table. I need a way to extract Just One occurrence of Each customer. Right now there are multiple Exsistences of the same info over and over and I just want to create on Table with the info then a relationship. What would be the best way to go about this?? thanks in advance.


- maximum

 

[Tranman]

Hi,
Depending on your data, you may have to comb through it a couple of times, but essentially what you need to do is write a query that returns the CIS info that you want (omit stuff like order date; etc) then go into SQL view of the query and insert the word DISTINCT after SELECT, ie:

SELECT DISTINCT CUSTNO, FNAME, LNAME, ADDR1, ADDR2, CITY, STATE, ZIP, .... whatever.

This query will return a row for each unique customer. Unfortunately, if you have any customers where the address has changed; etc. you will get a row for each of them, too.

To make a CIS table, just create a MakeTable query, and use the above query as its input.

Anyway, it's a place to start...

Paul