If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to create different parameters for the same report
Not being too dumb. I have created a training qualifications db and the
subsequent report, however, it would be good to be able to have the a report that can select either by Full Report, Report by Qualification type by member, Report By member by qualification. In the 2nd and 3rd report an option would need to be required to be able to select which qualification or member you wanted the report to show so that the report will show only the individual members qualifications or all those members qualified in a particular qualification. I hope i didnt ramble too much. Any assistance is much appreciated |
#2
|
|||
|
|||
How to create different parameters for the same report
Keith, you can do this if you leave the criteria out of the query that feeds
the report. Instead, use a form where the user can enter the criteria, and click a button to open the report. The button's Click event procedure builds up a string from the boxes that have a value, and uses it as the WhereCondition of OpenReport. The string you need has to look like the WHERE clause of a query, so you can mock up a query and enter any literal values as criteria. Then switch to SQL View (View menu in query design), and look at the WHERE clause in the query statement. You will need to have some VBA coding skills to achieve the very flexible interface you are aiming for. For a basic example, see Method 2 in this article: Limiting a Report to a Date Range at: http://allenbrowne.com/casu-08.html -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Keith Squibb" Keith wrote in message ... Not being too dumb. I have created a training qualifications db and the subsequent report, however, it would be good to be able to have the a report that can select either by Full Report, Report by Qualification type by member, Report By member by qualification. In the 2nd and 3rd report an option would need to be required to be able to select which qualification or member you wanted the report to show so that the report will show only the individual members qualifications or all those members qualified in a particular qualification. I hope i didnt ramble too much. Any assistance is much appreciated |
#3
|
|||
|
|||
How to create different parameters for the same report
Thanx Allen, I will give it a bash(not very VBA cluey here)
PS - Finally WA looks like its getting on the map hehe Regards fellow sandgroper "Allen Browne" wrote: Keith, you can do this if you leave the criteria out of the query that feeds the report. Instead, use a form where the user can enter the criteria, and click a button to open the report. The button's Click event procedure builds up a string from the boxes that have a value, and uses it as the WhereCondition of OpenReport. The string you need has to look like the WHERE clause of a query, so you can mock up a query and enter any literal values as criteria. Then switch to SQL View (View menu in query design), and look at the WHERE clause in the query statement. You will need to have some VBA coding skills to achieve the very flexible interface you are aiming for. For a basic example, see Method 2 in this article: Limiting a Report to a Date Range at: http://allenbrowne.com/casu-08.html -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Keith Squibb" Keith wrote in message ... Not being too dumb. I have created a training qualifications db and the subsequent report, however, it would be good to be able to have the a report that can select either by Full Report, Report by Qualification type by member, Report By member by qualification. In the 2nd and 3rd report an option would need to be required to be able to select which qualification or member you wanted the report to show so that the report will show only the individual members qualifications or all those members qualified in a particular qualification. I hope i didnt ramble too much. Any assistance is much appreciated |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Parameter thru Form Dialog Box for REPORT | Sandy | Setting Up & Running Reports | 16 | January 10th, 2006 10:06 AM |
Has anyone seen this behaviour? What might it be? | tw | General Discussion | 4 | June 30th, 2005 03:23 PM |
To Sharkbyte and all: Calculate a total values in group level | Ally | General Discussion | 6 | June 13th, 2005 08:16 PM |
Help!! I'm running around in circles! | CathyA | New Users | 19 | December 12th, 2004 07:50 PM |
Save Report With CreateReport Coding Issue | Jeff Conrad | Setting Up & Running Reports | 8 | July 12th, 2004 08:39 AM |