Too complex or incorrectly typed

[SeBasTiaan]

Hello, when I use the following query I get an error:

This expression is typed incorrectly, or it's too complex to be evaluated.
What am I doing wrong?

SELECT tblCursist.Naam, tblAbsentie.Datum, tblAbsentie.Lesuur, tblAbsentie.AantalLesuren, tblAbsentie.Deelkwalificatie, tblAbsentie.Docent, tblAbsentie.Gemotiveerd, tblAbsentie.Reden, tblAbsentie.Status, qryCountLesuren.SumOfAantalLesuren
FROM (tblCursist INNER JOIN qryCountLesuren ON tblCursist.OVnr = qryCountLesuren.OVnr) INNER JOIN tblAbsentie ON tblCursist.OVnr = tblAbsentie.OVnr
WHERE (((tblAbsentie.Datum) Between [Voer begindatum in] And [Voer einddatum in]) AND ((tblAbsentie.OVnr) In ("[forms]![frmAbsentieInvoeren]![txtCursisten]")));