Criteria (1 Viewer)

SELECT qryInspectionsDue.FleetID, qryInspectionsDue.Employee, qryInspectionsDue.InspectionDate, qryInspectionsDue.Mileage, qryInspectionsDue.DueDate, qryInspectionsDue.DueRenewal, qryInspectionsDue.DueYear, qryInspectionsDue.Months
FROM qryInspectionsDue
WHERE (((qryInspectionsDue.DueYear)=[Enter Year Required]) AND ((qryInspectionsDue.Months) Between [Start Month] And [End Month]));

SELECT qryInspectionsDue.FleetID, qryInspectionsDue.Employee, qryInspectionsDue.InspectionDate, qryInspectionsDue.Mileage, qryInspectionsDue.DueDate, qryInspectionsDue.DueRenewal, qryInspectionsDue.DueYear, qryInspectionsDue.Months
FROM qryInspectionsDue
WHERE (((qryInspectionsDue.DueYear)=[forms]![frmFleetReports]![txtYear]) AND ((([qryInspectionsDue].[Months])>=[Forms]![frmFleetReports]![txtStartMonth])<=[Forms]![frmFleetReports]![txtEndMonth]));

SELECT qryInspectionsDue.FleetID, qryInspectionsDue.Employee, qryInspectionsDue.InspectionDate, qryInspectionsDue.Mileage, qryInspectionsDue.DueDate, qryInspectionsDue.DueRenewal, qryInspectionsDue.DueYear, qryInspectionsDue.Months
FROM qryInspectionsDue
WHERE (((qryInspectionsDue.DueYear)=[forms]![frmFleetReports]![txtYear]) AND ((([qryInspectionsDue].[Months])>=[Forms]![frmFleetReports]![txtStartMonth]) [COLOR="Red"]AND[/COLOR] <=[Forms]![frmFleetReports]![txtEndMonth]));

SELECT qryInspectionsDue.FleetID
	,qryInspectionsDue.Employee
	,qryInspectionsDue.InspectionDate
	,qryInspectionsDue.Mileage
	,qryInspectionsDue.DueDate
	,qryInspectionsDue.DueRenewal
	,qryInspectionsDue.DueYear
	,qryInspectionsDue.Months
FROM qryInspectionsDue
WHERE ((qryInspectionsDue.DueYear) = [forms]![frmFleetReports]![txtYear])
	AND (
		([qryInspectionsDue].[Months]) BETWEEN [Forms]![frmFleetReports]![txtStartMonth]
			AND [Forms]![frmFleetReports]![txtEndMonth]
		);