Results 1 to 3 of 3
  1. #1
    Join Date
    May 2015
    Posts
    2

    Question Unanswered: Allow user to create custom, filtered reports

    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. =)

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    496
    Provided Answers: 24
    In the report form, you would have combo boxes or text boxes.
    the report would either use the combo in the qquery
    select * from table where [dept] = forms!frmReport!cboDept.
    OR

    If you have many boxes and SOME are selected, then you must determine what got picked then filter in the openReport clause.

  3. #3
    Join Date
    May 2015
    Posts
    2
    Quote Originally Posted by ranman256 View Post
    In the report form, you would have combo boxes or text boxes.
    the report would either use the combo in the qquery
    select * from table where [dept] = forms!frmReport!cboDept.
    OR

    If you have many boxes and SOME are selected, then you must determine what got picked then filter in the openReport clause.
    Yes, I'm trying to do the second thing you described. However, I don't know exactly how to accomplish what we've described.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •