PDA

View Full Version : Solved: Generating Report Based on Multiple Criteria



itipu
03-17-2010, 12:52 PM
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.

orange
03-18-2010, 06:22 AM
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

itipu
03-18-2010, 06:33 AM
Thanks Orange, I have created a Query by Form .. but also having issues there.. se my other thread. Thanks a lot!