Search results

Thanks Paul, this function works but there are instances where there are multiple user's under a specialist column. When i do the above it only brings back one of the users. Is there a way to pull in both?

Thanks Paul for your reply. Not sure how to go about applying the code you sent me via the link. Can you elaborate alittle on what it will do?

I have created a query to specify the different reps assigned to a particular account. The output is below: Account NameAccount IDAccount CSNXX Account IdLogin NameUnique ID1stLine MgrAccount MgrA SpecialistB SpecialistC SpecialistAB OverlayCD OverlayABC INC123452158436A-100883User...

Sweet Deal! Thank you Kiwiman it worked like a charm. :) I guess I was making it harder on myself. Thanks again man, cheers.

Hello Everyone, I am new to Access and I am trying to write a formula in the control source of a field to calculate the number of years after a termination date is entered. I got the formula to work when the field is populated but I am having a hard time putting a formula together to take into...