query problem

  • Thread starter Thread starter jfeketet via AccessMonster.com
  • Start date Start date
J

jfeketet via AccessMonster.com

Hi to Everyone
I have a table (tblMunka) with the following columns: JobId;
PersonalId;AreaId;StartDate;EndDate;ActiveJob
I would like to a query which tell me how many personal was in a term in an
area. I have a form (frmLetszam) where user can choose start and end dates
from a calendar.
I've tried with this but the result is not good:
HAVING (((tblMunka.StartDate) Between [Forms]![frmLetszam]![cboEndDate] And
[Forms]![frmLetszam]![cboEndDate])) OR (((tblMunka.StartDate)<[Forms]!
[frmLetszam]![cboStartDate]) AND ((tblMunka.EndDate) Is Not Null));

Please help me!
Best regards
 
You have between the same two dates - [Forms]![frmLetszam]![cboEndDate].
Try this ---
HAVING tblMunka.StartDate Between [Forms]![frmLetszam]![cboEndDate] And
[Forms]![frmLetszam]![cboStartDate]
 
Back
Top