Merging Queries

[Guest]

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

 

[guido via AccessMonster.com]

I don't know if I understand correctly or not. It sounds like you have one
table in your query, so I'm not sure what you were unioning together. If it
is just one table that you want the records where there is a 'No' in one or
more of the fields, you can do the following. In the criteria area of the
query, put 'No' under each field in a different row - not accross the same
row.
That is the difference between
WHERE (((Table1.Wk1)="No")) OR (((Table1.Wk1)="No")) OR (((Table1.Wk1)="No"))
OR (((Table1.Wk1)="No"))
and
WHERE (((Table1.Wk1)="No")) AND (((Table1.Wk1)="No")) AND (((Table1.Wk1)="No")
) AND (((Table1.Wk1)="No"))