Just like with the owners, I MUST GROUP the records. Thus, I know that I have to use "HAVING" now.
At this time, however, given the alias, it creates a new field (expression) vs. plugging the listbox value into the existing NCode_Group: NCode_Group([N_Code]).
I 99% confident that once I have a correct strCriteria, the original process will work for this one too.
Any thoughts on how to rewrite the line?
strCriteria = "Q201_CFT_Participation_Report_Ncode_Gonzales_ RPT.NCode_Group = '" & Me!lstCFTParticipants.ItemData(varItem) & "'"
Pls refer back to the images of the "Before" and "After". After query execution, the query (in design) must just like the "Before"... but it doesn't... urgh!