Hi - thanks for looking at my question :)
I am using a very simple Select Distinct query in my ASP recordset.
There is another column in the table called Resource_Group that I need to access from my recordset
sqltext="Select DISTINCT(Resource_Owner) from MDM_REQUEST_RESOURCES where Request_ID ='"&varRequest_ID&"' AND Resource_Type=2 AND Approved='A'"
Is this possible?