Hello,
I'm not sure how easy or if indeed it is possible but I have a query that is pulling through values for contacts. I have two tables Accounts and Contacts, for some reason or another the values in contacts have duplicates of the same contact but a seperate job titles. See below....
0018544 DarthVader MD
0018544 DarthVader Employee
0018544 DarthVader Store Assistant
0018559 MARKSWALLOWS FD
0018559 MARKSWALLOWS MD
0018636 Johnny Cash Employee
0018636 Johnny Cash Employee
I would like to if possible from that return
1st MD
2nd FD
3rd Employee
4th Store assistant
Is this possible?
Any help is appreciated.
Thanks
L
I'm not sure how easy or if indeed it is possible but I have a query that is pulling through values for contacts. I have two tables Accounts and Contacts, for some reason or another the values in contacts have duplicates of the same contact but a seperate job titles. See below....
0018544 DarthVader MD
0018544 DarthVader Employee
0018544 DarthVader Store Assistant
0018559 MARKSWALLOWS FD
0018559 MARKSWALLOWS MD
0018636 Johnny Cash Employee
0018636 Johnny Cash Employee
I would like to if possible from that return
1st MD
2nd FD
3rd Employee
4th Store assistant
Is this possible?
Any help is appreciated.
Thanks
L