Report Parameters on Form

[Alan V via AccessMonster.com]

I have a report form with the following parameters: fromdate, todate,
assignedto, companyname.

All my reports are created so that when the user picks the from and to date
on the form and clicks on a report button, they get the report filtered for
that date range.

How to I filter the report so that when they pick a person “assignedTo” from
the drop-down on the form, and have the report only show data for that person
and for the date range?

Thanks,
Alan...

 

[Guest]

Same way it is filtering now. Just add "assigned to" to the criteria.

 

[Alan V via AccessMonster.com]

I'm not sure what to code in the query for the "assignedTo" field. For the
date field I have: Between [FromDate] And [ToDate]

Here is a copy of my SQL query:

SELECT qryResolution.TrackingNo, qryResolution.CompanyName, qryResolution.
CustomerNo, qryResolution.AssignedTo, qryResolution.ReportedDate,
qryResolution.AssignedDate, qryResolution.IssueType, qryResolution.Reportedby,
tblParm.FromDate, tblParm.ToDate, tblParm.AssignedTo
FROM qryResolution INNER JOIN tblParm ON qryResolution.ReportedDate = tblParm.
FromDate
WHERE (((qryResolution.AssignedTo)=[Forms]![frmReportPanel]![AssignedTo]) AND
((qryResolution.ReportedDate) Between [FromDate] And [ToDate]));

Same way it is filtering now. Just add "assigned to" to the criteria.

I have a report form with the following parameters: fromdate, todate,
assignedto, companyname.

[quoted text clipped - 9 lines]

Thanks,
Alan...

 

[Guest]

That looks like it should work

I'm not sure what to code in the query for the "assignedTo" field. For the
date field I have: Between [FromDate] And [ToDate]

Here is a copy of my SQL query:

SELECT qryResolution.TrackingNo, qryResolution.CompanyName, qryResolution.
CustomerNo, qryResolution.AssignedTo, qryResolution.ReportedDate,
qryResolution.AssignedDate, qryResolution.IssueType, qryResolution.Reportedby,
tblParm.FromDate, tblParm.ToDate, tblParm.AssignedTo
FROM qryResolution INNER JOIN tblParm ON qryResolution.ReportedDate = tblParm.
FromDate
WHERE (((qryResolution.AssignedTo)=[Forms]![frmReportPanel]![AssignedTo]) AND
((qryResolution.ReportedDate) Between [FromDate] And [ToDate]));

Same way it is filtering now. Just add "assigned to" to the criteria.

I have a report form with the following parameters: fromdate, todate,
assignedto, companyname.

[quoted text clipped - 9 lines]

Thanks,
Alan...