Mitch2007 (8/5/2009)
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?
Is it a one to many relationship between the two tables?