Is there a way to make this query work if arrays srtList1 and srtList2 are empty. At present I am evauating each to see if one/both/none are filled and then having 4 queries instead of just one. Thanks
& "AND TXCLIPS.Shot IN (" & Mid(strList2, 2) & ")" _
& "AND TXCLIPS.StarRating IN (" & Mid(strList3, 2) & ")" _
& "AND TXCLIPS.Shot IN (" & Mid(strList2, 2) & ")" _
& "AND TXCLIPS.StarRating IN (" & Mid(strList3, 2) & ")" _