Rachel,

I think you will find the you have falen into the =/==/eq trap in your if statements, they should read

$sql .= "where DriveInitiative = $initiative" 
if ($initiative eq 'on');
[download]

You could always try printing the $sql variable before you prepare it with something like

print qq($sql<BR>);
[download]