>I would suggest to stop trying to do the whole job with one query. Keep your original query to get the dat with memos with an added filed for firstvideo number like "..., 0 as FirstVideo ...". Make that query READWRITE. Then do a scan loop and fire my suggestion to simply get the first video number for each program. Something like this;

This is coming from VB.NET by the use of OleDB, so I have to do everything in one big SQL.