Conditional Reports

[kida]

I have two slightly different reports. Both are results reports but, one is for one type of result and the other report is for another type of result.
Basically I'm trying to run one type of report on a group of people over a certain age requirement and run another report if the group of people don't meet that age requirement.

Clear as mud?
Any help would be great.
Thanks

 

[dhookom]

Is there a question here? If so, we need more information about significant table and field names, report names, etc.

If the reports are only slightly different, I would attempt to combine them into a single report and then set various properties of controls as needed for each age group.

Duane
Hook'D on Access
MS Access MVP

 

[sxschech]

Is the only difference between the reports the age requirement, or are there format/layout differences?

 

[kida]

The only difference between the two groups is the age.
If the age is greater than 8, the report has a sort/group by resulting score and shows the resulting score and the placing (first place, second place, third place, etc.)
If the age is below 9, the final score is not shown but, there is a calculation based on the final score. That calculation will show a level (i.e. final score between 8 and 10, the level is "A", final score between 7 and 8, the level is "B", final score between 6 and 7, the level is "c", etc.) This report has a sort/group by a unique number representing the person.
I'm looking for something that analyzses the resulting data, if the age is less than 9, it runs one report, if the age is equal to or greater than 9, it runs another report. Since the reports are sorted/grouped differenlty, I beleive they have to be different reports!?!?

 

[dhookom]

You can change a lot of properties including sorting and grouping using code. However, this might not be the best considering your needs.

You haven't really answered my question

we need more information about significant table and field names, report names, etc.

We don't know the names of the reports or how the age is stored or much else. Do you want to use a button on a form to open the report?

Duane
Hook'D on Access
MS Access MVP