Welcome, Chris. Glad you got it working.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
<annysjunkmail@... wrote
Hi Max,
I know why it doesn't work. My ID numbers were formatted as text (the
original file comes from Access 2000 where the ID field is a text
field). After converting ID's to numbers it worked fine.
Thanks very much for your expertise and sample workbook.
A very clever solution indeed!
Regards
Chri