On a report, I have a txtField that is receiving data from a lookup:
txtHRTech =[HR Tech].[Column](1)
Column 0 is the ID No.
Column 1 is the First Name Last Name
Column 2 is the Email Address
This field is part of a 'group' and all the HRTech data is group together. Works...