Thanks for posting back with the db but the information is missing from the sql. If you can post back with the full sql that includes the records from these tables and I will help look into this further with you. I think that you either need to set the looping up differently or there might need to be another recordset and/or repeat region to do this. Please post back with the data so that I can give this a test with your info to see what would need to be done.