How to filter out duplicate records (1 Viewer)

[mr_metrics]

Hi, I am using access 2000 to connect to two other databases, one is Siebel and one Kana (customer service email software). Every now and then duplicate records pop in there. I can tell because the date/time stamp is the same right down to the seconds. Is there a function I can write that will only accept one record if it finds dups?

thanks

 

[Randomblink]

Goto the Help Pages and look for Duplicate Records. I am having a similiar error and if you open your Query, double-click in the Query window anywhere EXCEPT for the design grid or the table view and the properties window pops up. From the properties window select the UniqueValue or Record selection to Yes or no...it only works if you have more than one table in your Query so...good luck...
My problem is with ONE table being queried...

 

[Pat Hartman]

If you want to prevent them from being appended to your table, create a unique index on the Date/Time column.

 

[mr_metrics]

I am using only one table too. but this unique index on the date/time column sounds interesting, how do i do that?

 

[mr_metrics]

never mind, i figured out the primary key index business...thanks!