Total in Report by Group

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

Guest

I have a report that is grouped by Artist's Name and I need to get the Total
Amount Paid to each Artist. I have tried adding a text box (unbound) and
having the controlsource set to =SUM([Amount to Artist]) and I've put it in
the GRoup Footer, but it's not working. Does anyone know what I'm missing?
I'm pretty new when it comes to Access.
Thank so much
 
" it's not working" doesn't tell us much. Is the [Amount to Artist] field
numeric? Is it a field in your report's record source?

Normally this works in group headers and footers:
=Sum([Numeric Field Name])
 
If [Amount to Artist] is the name of your control in your report, that's the
problem. You'll need to use something like

=Sum[TheNameOfTheUnderlyingField]

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I apologize for that. Yes the Amount to Artist is a numeric field it's
actually a Calculated Currency. Maybe that has something to do with it? Yes
Amount to Artist in a field in the report's record source.

Duane Hookom said:
" it's not working" doesn't tell us much. Is the [Amount to Artist] field
numeric? Is it a field in your report's record source?

Normally this works in group headers and footers:
=Sum([Numeric Field Name])

--
Duane Hookom
Microsoft Access MVP


Esaw said:
I have a report that is grouped by Artist's Name and I need to get the Total
Amount Paid to each Artist. I have tried adding a text box (unbound) and
having the controlsource set to =SUM([Amount to Artist]) and I've put it in
the GRoup Footer, but it's not working. Does anyone know what I'm missing?
I'm pretty new when it comes to Access.
Thank so much
Click to expand...
Click to expand...
 
Nope, "Amount to Artist" is the name of the field.

Jeff Boyce said:
If [Amount to Artist] is the name of your control in your report, that's the
problem. You'll need to use something like

=Sum[TheNameOfTheUnderlyingField]

Regards

Jeff Boyce
Microsoft Office/Access MVP


Esaw said:
I have a report that is grouped by Artist's Name and I need to get the
Total
Amount Paid to each Artist. I have tried adding a text box (unbound) and
having the controlsource set to =SUM([Amount to Artist]) and I've put it
in
the GRoup Footer, but it's not working. Does anyone know what I'm missing?
I'm pretty new when it comes to Access.
Thank so much
Click to expand...
Click to expand...
 
I'm not familiar with "Calculated Currency". Maybe you should provide the SQL
view of the report's record source. I expect you are applying a format to the
field/column.

When you view the datasheet of the record source, are the [Amount to Artist]
values left or right-aligned? If they are left-aligned then they are not
numeric.

--
Duane Hookom
Microsoft Access MVP


Esaw said:
I apologize for that. Yes the Amount to Artist is a numeric field it's
actually a Calculated Currency. Maybe that has something to do with it? Yes
Amount to Artist in a field in the report's record source.

Duane Hookom said:
" it's not working" doesn't tell us much. Is the [Amount to Artist] field
numeric? Is it a field in your report's record source?

Normally this works in group headers and footers:
=Sum([Numeric Field Name])

--
Duane Hookom
Microsoft Access MVP


Esaw said:
I have a report that is grouped by Artist's Name and I need to get the Total
Amount Paid to each Artist. I have tried adding a text box (unbound) and
having the controlsource set to =SUM([Amount to Artist]) and I've put it in
the GRoup Footer, but it's not working. Does anyone know what I'm missing?
I'm pretty new when it comes to Access.
Thank so much
Click to expand...
Click to expand...
Click to expand...
 
Thanks for hanging in there with me. I don't understand a lot of Access,
hence why I may not be able to express it well. What I mean by Calculated
Currency is that the value in the field is calculated (=[Royalty Amount] -
[Commission]) and yes I did apply the Currency format to a text field.



Duane Hookom said:
I'm not familiar with "Calculated Currency". Maybe you should provide the SQL
view of the report's record source. I expect you are applying a format to the
field/column.

When you view the datasheet of the record source, are the [Amount to Artist]
values left or right-aligned? If they are left-aligned then they are not
numeric.

--
Duane Hookom
Microsoft Access MVP


Esaw said:
I apologize for that. Yes the Amount to Artist is a numeric field it's
actually a Calculated Currency. Maybe that has something to do with it? Yes
Amount to Artist in a field in the report's record source.

Duane Hookom said:
" it's not working" doesn't tell us much. Is the [Amount to Artist] field
numeric? Is it a field in your report's record source?

Normally this works in group headers and footers:
=Sum([Numeric Field Name])

--
Duane Hookom
Microsoft Access MVP


:

I have a report that is grouped by Artist's Name and I need to get the Total
Amount Paid to each Artist. I have tried adding a text box (unbound) and
having the controlsource set to =SUM([Amount to Artist]) and I've put it in
the GRoup Footer, but it's not working. Does anyone know what I'm missing?
I'm pretty new when it comes to Access.
Thank so much
Click to expand...
Click to expand...
Click to expand...
 
I wasn't aware that you could "apply the Currency format to a text field".
Currency format can be applied to a numeric field and I assumed would have no
effect on a text/string field.

You didn't reply to my alignment question.

--
Duane Hookom
Microsoft Access MVP


Esaw said:
Thanks for hanging in there with me. I don't understand a lot of Access,
hence why I may not be able to express it well. What I mean by Calculated
Currency is that the value in the field is calculated (=[Royalty Amount] -
[Commission]) and yes I did apply the Currency format to a text field.



Duane Hookom said:
I'm not familiar with "Calculated Currency". Maybe you should provide the SQL
view of the report's record source. I expect you are applying a format to the
field/column.

When you view the datasheet of the record source, are the [Amount to Artist]
values left or right-aligned? If they are left-aligned then they are not
numeric.

--
Duane Hookom
Microsoft Access MVP


Esaw said:
I apologize for that. Yes the Amount to Artist is a numeric field it's
actually a Calculated Currency. Maybe that has something to do with it? Yes
Amount to Artist in a field in the report's record source.

:

" it's not working" doesn't tell us much. Is the [Amount to Artist] field
numeric? Is it a field in your report's record source?

Normally this works in group headers and footers:
=Sum([Numeric Field Name])

--
Duane Hookom
Microsoft Access MVP


:

I have a report that is grouped by Artist's Name and I need to get the Total
Amount Paid to each Artist. I have tried adding a text box (unbound) and
having the controlsource set to =SUM([Amount to Artist]) and I've put it in
the GRoup Footer, but it's not working. Does anyone know what I'm missing?
I'm pretty new when it comes to Access.
Thank so much
Click to expand...
Click to expand...
Click to expand...
 
Back
Top