Access Finding and deleting duplicate records. MS Access Help ASAP


Joined
Sep 9, 2006
Messages
1
Reaction score
0
I need HELP: Finding and deleting duplicate records. MS Access Help ASAP

I am trying to build a database in Access to do the following.

I want to import two excel spreadsheets into access.
From the two documents I want to identify duplicate rows. I want to identify the duplicate records between the two spreadsheets and delete duplicates. By comparing these two spreadsheet I want to create a new spreadsheet to compare with for the next week and so on and so on. Example

Table 1
ABC 123 IIJ Y

Table 2
ABC 123 IIJ

I want to identify these in a separate report and delete them from the master report. "Y" in Table 1 means that the row is completed and does not to be in Table 2, so delete both. Another example

Table 1
ABC 123 IIJ N

Table 2
ABC 123 IIJ

In this example I want to delete the row that does not contain the N in one of the columns and delete the other. N in Table 1 means that the row is required for the next report so I need this item, delete the row from Table 2.

This is a weekly report so I want to be able to identify what I delete as well as create a new table to compare against the new week. So far all I have been able to do is query and put the two tables together. If anyone can help me with this situation I would really appreciate.
 
Last edited:
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top