Checking for doubles

Giganews Newsgroups
Subject: Checking for doubles
Posted by:  john (jo…@test.com)
Date: Sun, 27 Aug 2006

I've made an import macro to import bank transactions. Those transactions
don't have an ID_number when downloaded from internet. They get it when they
are added to the main transaction table in my database. When adding them I
would like to check if they haven't accidentally been added already, based
on account nr, date, amount of money, and payers info. What would be the
best way of doing this without actually having to program in VB?
Thanks in advance,
john

Replies