Print certain information

[corpusaggie]

I have a reports that can be printed based on the race of certain students - at times I want all of the students printed and at times I only want students of certain races printed...so, is there any way to specify this instead of creating all the different reports? Basically - can a pop up box be created that would allow the user to enter the race of the students to be printed or allow them to print all the students? Does this make sense? Can anyone help?

 

[Dreamboat]

Sure. Create ONE query. In the race field criteria, put:

[Enter desired selection] or something like that.

When you run the query, you can enter the value of the race you are looking for, and hit ok. If you base your report on that query, you'll be asked the same thing when you run the report.

 

[corpusaggie]

Thanks...that helped...one more question though...can I default the query to select all of the races? Basically I want the user to be able to select a certain one or all...now is that possible?

 

[Chris RR]

The cheap and easy way out is to make two versions of the query. One uses the [entered desired selection] parameter, the other retrieves all the students. Then you put two buttons on your form. One says something like "Selected Students", and runs the parameter query, while the other says "All Students", and runs the other query.

There are much more elegant ways of doing this in code, but if this is all you need it will work fine.

 

[David R]

You can also use [Enter race, or leave blank for all] & "*"

David R