Allow user to create custom, filtered reports in Access

[zzzjoshzzz]

I have a normalized database with (let's say) the following tables:

tblProjects
tblStaff
tblProjectPhase
tblOffice


I need a way to allow the end user to be able to create custom reports that show only projects in certain phases (let's say planning and construction) AND that are from certain Offices (let's say Office 1 and 3 but not 2) AND that were started between a certain date range.


What I'm envisioning is a checkbox-style form that has a 'create report' button at the bottom.

Your help is MUCH APPRECIATED. =)

 

[Joe4]

Cross-post: Allow user to create custom, filtered reports

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #10 here: http://www.mrexcel.com/forum/showthread.php?t=99490).

This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

For a more complete explanation on cross-posting, see here: http://www.excelguru.ca/content.php?184).

 

[zzzjoshzzz]

Cross-post: Allow user to create custom, filtered reports

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #10 here: Forum Rules).

This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

For a more complete explanation on cross-posting, see here: Excelguru Help Site - A message to forum cross posters).

Thanks,
Yes - this is a cross post.

 

[Joe4]

In the future, please include links to the other posts on the other forums.

Thanks