$query .= " AND a.transdate >= '$form->{transdatefrom}'" if $form->{transdatefrom};
$query .= " AND a.transdate <= '$form->{transdateto}'" if $form->{transdateto};
}
$query .= " AND a.transdate >= '$form->{transdatefrom}'" if $form->{transdatefrom};
$query .= " AND a.transdate <= '$form->{transdateto}'" if $form->{transdateto};
}