B
Bart
I want to append only non existing ClientID fields into the
destination table.
Client ID is not a primairy field because it is a import file from
website(can't put it in primairy key because import program refresh
the table every 5 minutes and replaces all data.)
So i do a append query with this criteria:
=not Exists (SELECT 'KlantID' from [Klant_copy] where
[Klant_copy].KlantID =
[Klant].KlantID)
Klant= to be copied table (KlantID fields)
Klant_copy= destination table (also KlantID fields)
Can someone tell me why my append querie criteria does'nt work (to
copy only non existing KlantID field in the destination table).
Thanx in advance!
destination table.
Client ID is not a primairy field because it is a import file from
website(can't put it in primairy key because import program refresh
the table every 5 minutes and replaces all data.)
So i do a append query with this criteria:
=not Exists (SELECT 'KlantID' from [Klant_copy] where
[Klant_copy].KlantID =
[Klant].KlantID)
Klant= to be copied table (KlantID fields)
Klant_copy= destination table (also KlantID fields)
Can someone tell me why my append querie criteria does'nt work (to
copy only non existing KlantID field in the destination table).
Thanx in advance!