Formating a number

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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.
 
Back
Top