Count Number of double entries
Hi, In a table I have technicians that are working in more than one State. How I can count how many are they that are working in 2 States, and how many are working in for example in 3 States?
Forum Discussion
It would take me about an hour to sort this out with you on a GotoMeeting screen sharing call. I'm not really in a position to take the time to explain the click by click steps to you on this Forum. Contact me via the information on my website for on on one assistance.
You will need to have a table of unique techs and then a child table to that of the states that they are registered in. One Tech has many State Registrations.
You will need to have a table of unique techs and then a child table to that of the states that they are registered in. One Tech has many State Registrations.