Report Parameters on Form

  • Thread starter Thread starter Alan V via AccessMonster.com
  • Start date Start date
A

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...
 
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.
Click to expand...
[quoted text clipped - 9 lines]
Thanks,
Alan...
Click to expand...
Click to expand...
 
That looks like it should work

Alan V via AccessMonster.com said:
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.
Click to expand...
[quoted text clipped - 9 lines]
Thanks,
Alan...
Click to expand...
Click to expand...
Click to expand...
 
Back
Top