Report Parm

[Will Cohen via AccessMonster.com]

I have a report panel with FromDate and ToDate fields to choose date ranges
for my reports.

I have pre-defined my reports with the FromDate and ToDate on the reports.

I created a tblParm with FromDate and Todate fields in the table. In my
query, I joined the FromDate of the tblParm to the AssignDate of tblMain.
On my query AssignDate I place "Between [FromDate] And [ToDate]" as the
criteria.

Now at the report panel, I key in the to and from dates, but when I run my
report, the report is empty.

Can anyone tell me what I have done wrong or maybe missing an important
step??

Thanks,
Will

 

[Duane Hookom]

I think you just want to remove the join line in the query.