data is repeating???

[scrappe7]

Hello everyone,

I'm a summer intern and have been given a project to finish with office 97. I am having a problem when I import an excel file that has data for at least 3 sequential days. the import occurs everyday though. as a result if one of the data fields has not been removed from the excel file on the next day it again becomes imported to access. what occurs is a transaction does not clear and will remain in excel until it does. this means the same data can be reimported way too many times. I would like to tell access if it sees multiple fields that contain the same purchase date, settle date, size, client etc. it should delete any extra's. i basically need a query that will merge all twin data fields as one unique row of data. is this possible and how? thank you very much.

Ed

 

[xlbo]

2 ideas :
1: Do a Make Table Query on the main table in Access and use Group By on all the fields that may be duplicated and Average on the numeric fields

2: Use the built in "Find Duplicates" query and use the reults set from that to delete the records in your main table

HTH
Geoff