Thanks,

I'll try that and let you know how I go.

Cheers

Brett

Hi apf,

Assume that DB1 is the master and that the records from DB2 have to be merged. Is this what you need?

Thanks

Brett

Thanks Tom,

You headed me on the right path to a solution. I ended up using a series of IF statements to increment counters as follows: