SQL

Table 2 includes a field EXPLOSIVES which is either 1 or blank.

SELECT Table2.[month], Table2.[date], Table2.[year], dead, explosives

FROM Table2

where dead > 20 and EXPLOSIVES=1;

complains Enter parameter explosives.  What does it want?

SELECT Table2.[month], Table2.[date], Table2.[year], dead, explosives

FROM Table2

where dead > 20;

works fine.