Consulting

Results 1 to 3 of 3

Thread: Solved: Generating Report Based on Multiple Criteria

  1. #1
    VBAX Contributor
    Joined
    Feb 2007
    Posts
    126
    Location

    Solved: Generating Report Based on Multiple Criteria

    I have a rather simple table as attached. I would like user to be able to select criteria from the table on which he wants to report on. But since some of the criteria are always the same they shouldn't repeat as it currently does.. I.e. instead of my current form displaying everything line by line, I only want user to select under Platform BA, BB, BC and BD under Medium - Cube, Circle, Triangle.. and so on.. I obviously need many more tickboxes.. on the other hand if there is a better way I am more than interested.

  2. #2
    VBAX Tutor
    Joined
    Nov 2007
    Posts
    257
    Location
    Perhaps you could use a form and create some dialog boxes such that the user could select what should be reported.Here's a link to samples for dialog boxes.
    Good luck.

    http://www.fontstuff.com/access/acctut19.htm

  3. #3
    VBAX Contributor
    Joined
    Feb 2007
    Posts
    126
    Location
    Thanks Orange, I have created a Query by Form .. but also having issues there.. se my other thread. Thanks a lot!

Posting Permissions

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