Hi.
I have a number of linked tables which i'm trying to produce a report against.

Problem i have is that when the opertator runs the report, i need them to be able to enter a TO & FROM date range which will look against the PERIODTO & PERIODFROM fields from within tblRecords and return just those records on the report (rptRecords).

I've tried a number of things but to no avail!!!
Can someone assist in the best way of acheiving this please.
Regards
John

This is quite a frequent question, so I'm sure you should be Able to find something within this forum.

Alternatively you could have a look at this thread here, where there are several videos which go into the details of how to do it based on a form. (http://msaccesshintsandtips.ning.com/profiles/blog/show?id=948619%3ABlogPost%3A1321)




..