change Group name

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

Guest

i have created a report which basically uses group feature and lists the sume of all related information per group. But i want to change the name of a particular group to something else when is listed. here is the part of the list:

Type Xact Unique Gross

BIK 23 65 12345
KIS 12 34 12760

As you see the data are grouped by the type and other fields shows the sum of all records per group. I want to change the name of group KIS to group NCS .

Also what should i do in order to find the total of Xact, Unique and Gross for all groups in a way that appears right after the last group name? if i use the sum function in page footer it appears at the end of the page which i dont want.

all helps are appreciated.

thanks
Sasan
 
How about using a separate control to display the ID of the group, defined
as a calculated control:

= IIF([thisfld] = "KIS", "NCS", [thisfld])

Depending on other needs, e.g., the order in which you want the groups
displayed, you may wish to do this "translation" in the Query that is the
RecordSource of the Report.

Larry Linson
Microsoft Access MVP


Sasan said:
i have created a report which basically uses group feature and lists the
Click to expand...
sume of all related information per group. But i want to change the name of
a particular group to something else when is listed. here is the part of the
list:
Type Xact Unique Gross

BIK 23 65 12345
KIS 12 34 12760

As you see the data are grouped by the type and other fields shows the sum
Click to expand...
of all records per group. I want to change the name of group KIS to group
NCS .
Also what should i do in order to find the total of Xact, Unique and Gross
Click to expand...
for all groups in a way that appears right after the last group name? if i
use the sum function in page footer it appears at the end of the page which
i dont want.
 
Back
Top