Hello. I am having difficulty creating a query.
I have a hypothetical table with the following fields:
EventNumber
ActionType
State1
State2
State3
I want to run a query that will tell me how many times a State was linked to an EventNumber.
In other words, my date can look like this:
EventNumber Action Type State1 State2 State3 1 Alpha Virginia 2 Alpha Washington Alabama 3 Beta Nevada 4 Alpha Virginia Virginia 5 Gamma New York Florida Maine
When I run my query, "Virginia" should only be counted TWICE. Not three times. "Virginia" is mentioned once in #1 and twice in #4. I want State2:Virginia to be ignored because State2 already lists "Virginia"
To put it another way: If State1 = (State2 or State3) THEN IGNORE State2/State OR IF State2 = (State3), then IGNORE State3.
I hope that makes sense.