This is my solution
I hope you help them
private void getFaltas()
{
string dateString = dateTimePickerFalta.Value.ToString("yyyy/MM/dd");
adapter.SelectCommand = new OleDbCommand
("select p.codPersona, p.tipoPersona, p.nombreCompleto, p.grado, p.paralelo from Persona p where not exists(select ma.codPersona from MarcacionesAsistencia ma where ma.codPersona = p.codPersona and ma.fecha = # " + dateString + " #)", connection);
dataset.Clear();
adapter.Fill(dataset, "DTFaltas");
dataGridView1.DataSource = dataset;
dataGridView1.DataMember = "DTFaltas";
dataGridView1.Refresh();
reportViewerFaltas.Clear();
reportViewerFaltas.RefreshReport();
}