Self Join - To use a repeat region in recordset
I tried it but it didn't work. Yes, the desired result is to have oppo1 and oppo2 on the same line not showing as a separate entry. Do you have info on using nested recorsets? I've never tried to use it. This is the first time I've had a huge issue using joins. The desired result is to self join oppo1 and oppo2 so they are in the same row. The join I created accomplished this but it also lists the rows by themselves. I don't need the duplicate row and it won't work with the recordset repeat region
