How do I find unique records? (1 Viewer)

[wkubik]

I have a simple task. I have 2 ASCII files, each with one column of numeric data, such as:

3512112540000
3512125890000
3507658240001

etc.

Some entries are common between the two files and some are unique. Each file has maybe 5000 entries. I would like to use Access to determine which records are unique to each file and which are common between the files. Any help appreciated.

West

 

[EndersG]

You can use the DISTINCT command in a query to elimate duplicate instances of the same value thus producing a unique set of records. You can also use the "Find Duplicate Values" query wizard that Access (97 has it but I'm not sure if version 2K does) provides to isolate those values that have multiple occurences.