Formating a number

[Guest]

I have a report that is grouping and contains a numeric field that I need to
format depending on the group that it is in. So when the report is in a
specific group it does...

Example:
Group 1: Region - Number needs to be 4.5
Group 2: District - Number needs to be 3
Group 3: Team: - Number needs to be 3

Thanks in advance

 

[Duane Hookom]

This makes no sense to me. Perhaps you should provide some actual records
and how you would like them displayed on a report.

Generally, if I want to associate values with specific records from a table,
I add a field to store the associated value.

 

[Guest]

Report should look like

Region
East 2.3
West 3.2

District
Mid-Atlantic 2
North 3
South 3

Team
DC 3
Boston 3
Atlanta 3

The query that is running the report is pulling all the records and then the
report is grouping them, by level, however as I stated I need a specific
level to show the number as shown.

 

[Duane Hookom]

I can't see the actual records or the logic applied to sort this way.