T
treysoul
I have a table with calls scored Fields: "Wk1", "Wk2", "Wk3", "Wk4". The
data is either "Yes", "No", or "Exception" in the cells. I have a query for
each week that gives a summary for the week. What I am trying to do is
create a query/report that shows which reps for the month have not received a
call. (Value is "No") Union Query will not work because these are different
fields (per se).
Example:
Rep Name Wk1 Wk2 Wk3 Wk4
Smith, John No No
Peters, Molly No
Matthews, Eric No No
Jefferson, George No No
Thanks in advance
data is either "Yes", "No", or "Exception" in the cells. I have a query for
each week that gives a summary for the week. What I am trying to do is
create a query/report that shows which reps for the month have not received a
call. (Value is "No") Union Query will not work because these are different
fields (per se).
Example:
Rep Name Wk1 Wk2 Wk3 Wk4
Smith, John No No
Peters, Molly No
Matthews, Eric No No
Jefferson, George No No
Thanks in advance