Hi.
I am working on a report where I need to pull an emergency contact number for employees.
In our database, someone may have listed up to 9 people has their emergency contact and they have a seqence number assoicated with them. 1,2, 3, etc.
The problem I'm having is:
Some people have never entered a contact but I still need them to show up on my list. So I need blank fields.
Some people have entered several contacts, then removed some so they may have a contact number in sequence 1, 2, 5 or they may skip all the way to 9.
How do I pull in people who have never entered a contact and, pull in the other people's first contact record regardless of what the sequence number is on that field?
In other words, if someone doesn't have anything filled in for a contact period, I want them, if someone has 1 and 5 filled in, I want 1, if someone only has 9 filled in I want 9.
Any help will be appreciated!