netbeans – Dates Search (Scope) JDateChoser Java Access

Hi, I am doing a project where I have records with date fields, and I have to filter by date in JTable to then run the iReport report, and I can not run this filter. Use as a database ACCESSHow can I perform this filter query?

Private private void BUSCARActionPerformed (java.awt.event.ActionEvent evt) {
String query = "";

try it
if (fechabus.isSelected () == true) {
// Date fec = new Date ();
Date fec1 = from.getDate ();
Date fec2 = hasta.getDate ();
// date date1 = new java.sql.Date (fec.getTime ());
// date date2 = new java.sql.Date (fec.getTime ());
// table ("SELECT * FROM Invoices_Sales WHERE Date_Comp BETWEEN" + from.getDate () + "" AND "" + up.getDate () + "& # 39;");
Date fec = new date ();
fec = from.getDate ();
Date date = new java.sql.Date (fec.getTime ());
Table (date);
cant.setText ("" + datos.getRowCount ());
} & # 39;

if (client.isSelected () == true) {
Table (clients.getText ());
clienttext.setText ("");
clients.setText ("");
cant.setText ("" + datos.getRowCount ());
}
if (todo.isSelected () == true) {
Table ("");
cant.setText ("");
}
}
catch (exception e) {
JOptionPane.showMessageDialog (null, e);
}
}

This is the search form Search for customers and show everything if you can not do it through facha (month)