Hi All.. this is going to be tough to describe but hoping someone can give me an idea on how to accomplish what I need.
I have a query named qryActivityRefDetail based on some relational tables and is set as follows:
SELECT DISTINCT tblActivity.ID, [tblActivityType]![AcitivityTypeRefID] &...