Group heading and sums

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

Guest

Hi,

I'm trying to get Access to show the column headings only once compared to
showing them once per group. A believe it is a rather easy matter but can't
figure out how.

I would also like to change the Sum i.e. the group sum to a text based on
characteristics of the group. I've a table named accounts with the fields
account and group, a number of records i.e. a series of accounts e.g.
3010,3020,3030 etc are assigned to the group Revenue. So, I want to rename
the Sum to Sum [+group name from the group column in table accounts] but I
cant figure out how.

Thanks / Bell
 
You can place your column heading labels in Group Headers, Page Headers, or
Report Headers.

I don't understand your second question. Maybe you could provide some sample
records and desired display in your report.
 
Thanks, you solved my first problem.

I'll try to explain the second one better;

In the group footer I've a Sum that Summarizes the group of accounts, these
accounts are grouped according to the group column in the accounts table. Now
instead of expressing SUM when Access summrizes the various groups I want
Access to express Sum Revenue, and Sum Direct Costs etc. Since there are many
groups I cannot replace Sum by writing e.g. Sum Revenue since this would make
all group sums be expressed as Sum Revenue. See below

This is what it looks like now.
3010 x
3020 x
Sum xx

4010 -y
4020 -y
Sum -yy

This is what I would prefer.
3010 x
3020 x
Sum Revenue xx

4010 -y
4020 -y
Sum Direct Costs -yy

Hence 3010,3020 are assigned as Revenues in the groups field from the table
accounts just as 4010,4020 are assigned as Direct Costs

I hope it is more understandable this time and thanks once again.

/ Bell


"Duane Hookom" skrev:
You can place your column heading labels in Group Headers, Page Headers, or
Report Headers.

I don't understand your second question. Maybe you could provide some sample
records and desired display in your report.

--
Duane Hookom
MS Access MVP
--

Bell said:
Hi,

I'm trying to get Access to show the column headings only once compared to
showing them once per group. A believe it is a rather easy matter but
can't
figure out how.

I would also like to change the Sum i.e. the group sum to a text based on
characteristics of the group. I've a table named accounts with the fields
account and group, a number of records i.e. a series of accounts e.g.
3010,3020,3030 etc are assigned to the group Revenue. So, I want to rename
the Sum to Sum [+group name from the group column in table accounts] but I
cant figure out how.

Thanks / Bell
Click to expand...
Click to expand...
 
Can't you just bind a text box control to the Groups field? Or, use
="Sum " & [GroupFieldName]
--
Duane Hookom
MS Access MVP
--

Bell said:
Thanks, you solved my first problem.

I'll try to explain the second one better;

In the group footer I've a Sum that Summarizes the group of accounts,
these
accounts are grouped according to the group column in the accounts table.
Now
instead of expressing SUM when Access summrizes the various groups I want
Access to express Sum Revenue, and Sum Direct Costs etc. Since there are
many
groups I cannot replace Sum by writing e.g. Sum Revenue since this would
make
all group sums be expressed as Sum Revenue. See below

This is what it looks like now.
3010 x
3020 x
Sum xx

4010 -y
4020 -y
Sum -yy

This is what I would prefer.
3010 x
3020 x
Sum Revenue xx

4010 -y
4020 -y
Sum Direct Costs -yy

Hence 3010,3020 are assigned as Revenues in the groups field from the
table
accounts just as 4010,4020 are assigned as Direct Costs

I hope it is more understandable this time and thanks once again.

/ Bell


"Duane Hookom" skrev:
You can place your column heading labels in Group Headers, Page Headers,
or
Report Headers.

I don't understand your second question. Maybe you could provide some
sample
records and desired display in your report.

--
Duane Hookom
MS Access MVP
--

Bell said:
Hi,

I'm trying to get Access to show the column headings only once compared
to
showing them once per group. A believe it is a rather easy matter but
can't
figure out how.

I would also like to change the Sum i.e. the group sum to a text based
on
characteristics of the group. I've a table named accounts with the
fields
account and group, a number of records i.e. a series of accounts e.g.
3010,3020,3030 etc are assigned to the group Revenue. So, I want to
rename
the Sum to Sum [+group name from the group column in table accounts]
but I
cant figure out how.

Thanks / Bell
Click to expand...
Click to expand...
Click to expand...
 
A textbox solved my problem.

Thanks / Bell

"Duane Hookom" skrev:
Can't you just bind a text box control to the Groups field? Or, use
="Sum " & [GroupFieldName]
--
Duane Hookom
MS Access MVP
--

Bell said:
Thanks, you solved my first problem.

I'll try to explain the second one better;

In the group footer I've a Sum that Summarizes the group of accounts,
these
accounts are grouped according to the group column in the accounts table.
Now
instead of expressing SUM when Access summrizes the various groups I want
Access to express Sum Revenue, and Sum Direct Costs etc. Since there are
many
groups I cannot replace Sum by writing e.g. Sum Revenue since this would
make
all group sums be expressed as Sum Revenue. See below

This is what it looks like now.
3010 x
3020 x
Sum xx

4010 -y
4020 -y
Sum -yy

This is what I would prefer.
3010 x
3020 x
Sum Revenue xx

4010 -y
4020 -y
Sum Direct Costs -yy

Hence 3010,3020 are assigned as Revenues in the groups field from the
table
accounts just as 4010,4020 are assigned as Direct Costs

I hope it is more understandable this time and thanks once again.

/ Bell


"Duane Hookom" skrev:
You can place your column heading labels in Group Headers, Page Headers,
or
Report Headers.

I don't understand your second question. Maybe you could provide some
sample
records and desired display in your report.

--
Duane Hookom
MS Access MVP
--

Hi,

I'm trying to get Access to show the column headings only once compared
to
showing them once per group. A believe it is a rather easy matter but
can't
figure out how.

I would also like to change the Sum i.e. the group sum to a text based
on
characteristics of the group. I've a table named accounts with the
fields
account and group, a number of records i.e. a series of accounts e.g.
3010,3020,3030 etc are assigned to the group Revenue. So, I want to
rename
the Sum to Sum [+group name from the group column in table accounts]
but I
cant figure out how.

Thanks / Bell
Click to expand...
Click to expand...
Click to expand...
 
Back
Top