Hi Lynn,

thanks for the reply and forgive my delay but things here have been swamped.

I ran your Select qry and strangely enough only got the 1507 records and not the 1587 I expected.

Any thoughts on this?