Search results

MarkK - I can just read the AgentID in the first record, but I want to omit the second record, as the first one is the only one relevant. To my knowledge, that would require an aggregate function, which, I was hoping, was the FIRST function. I did try getting rid of the ActivityDate field...

I have a table that my agents use to track activity. In a query, I am trying to determine how many accounts have had some work on them, when they were first worked, and by whom. However, there might be multiple activity records for each account entered by different agents. To do this, I have a...