Total in Report by Group

[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

 

[Guest]

" 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])

 

[Jeff Boyce]

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

 

[Guest]

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

 

[Guest]

Nope, "Amount to Artist" is the name of the field.

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 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

 

[Guest]

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

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

 

[Guest]

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.

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

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

 

[Guest]

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

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.

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

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