How to create different parameters for the same report

[Keith Squibb]

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

 

[Allen Browne]

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

 

[Keith Squibb]

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