Sum in bottom of report

  • Thread starter Thread starter Michel Ank
  • Start date Start date
M

Michel Ank

Hi all,

I have a field that your source is a Sql Query. I need show the sum of
field in bottom of report, but =Sum([field]) not functions, because
your Source is a Query SQL. how to do?

thanks
Michel Ank
 
Michel said:
Hi all,

I have a field that your source is a Sql Query. I need show the sum of
field in bottom of report, but =Sum([field]) not functions, because
your Source is a Query SQL. how to do?

thanks
Michel Ank
Click to expand...

Sum(field) will work, but not in a page header or footer. You have to use it in
a report header/footer or a group header/footer. Using a query, table, or SQL
statement as your RecordSource makes no difference at all.
 
Hi Rick,

Sorry, but I not understand.
Where I need makes a field?
Exist a way for me create this using VBA? I need to use a SUM in the
fields, because the report can will have a filter.

PS: I'm Braziliam and not speak in english right ok?

Thanks,
Michel


Rick Brandt escreveu:
Michel said:
Hi all,

I have a field that your source is a Sql Query. I need show the sum of
field in bottom of report, but =Sum([field]) not functions, because
your Source is a Query SQL. how to do?

thanks
Michel Ank
Click to expand...

Sum(field) will work, but not in a page header or footer. You have to use it in
a report header/footer or a group header/footer. Using a query, table, or SQL
statement as your RecordSource makes no difference at all.
Click to expand...
 
What Rick is suggesting is to view your report's Footer section (not the
Page footer). Add a text box to the Report Footer and set its Control Source
property to something like:
=Sum([YourNumericFieldName])

--
Duane Hookom
MS Access MVP

Michel Ank said:
Hi Rick,

Sorry, but I not understand.
Where I need makes a field?
Exist a way for me create this using VBA? I need to use a SUM in the
fields, because the report can will have a filter.

PS: I'm Braziliam and not speak in english right ok?

Thanks,
Michel


Rick Brandt escreveu:
Michel said:
Hi all,

I have a field that your source is a Sql Query. I need show the sum of
field in bottom of report, but =Sum([field]) not functions, because
your Source is a Query SQL. how to do?

thanks
Michel Ank
Click to expand...

Sum(field) will work, but not in a page header or footer. You have to
use it in
a report header/footer or a group header/footer. Using a query, table,
or SQL
statement as your RecordSource makes no difference at all.
Click to expand...
Click to expand...
 
Hi Duane,

I'm using of this way, but when I sending the Report to Print, it's ask
me a parameter with Field of Sum.


Michel Ank

Duane Hookom escreveu:
What Rick is suggesting is to view your report's Footer section (not the
Page footer). Add a text box to the Report Footer and set its Control Source
property to something like:
=Sum([YourNumericFieldName])

--
Duane Hookom
MS Access MVP

Michel Ank said:
Hi Rick,

Sorry, but I not understand.
Where I need makes a field?
Exist a way for me create this using VBA? I need to use a SUM in the
fields, because the report can will have a filter.

PS: I'm Braziliam and not speak in english right ok?

Thanks,
Michel


Rick Brandt escreveu:
Michel Ank wrote:
Hi all,

I have a field that your source is a Sql Query. I need show the sum of
field in bottom of report, but =Sum([field]) not functions, because
your Source is a Query SQL. how to do?

thanks
Michel Ank

Sum(field) will work, but not in a page header or footer. You have to
use it in
a report header/footer or a group header/footer. Using a query, table,
or SQL
statement as your RecordSource makes no difference at all.
Click to expand...
Click to expand...
Click to expand...
 
If you are asked for the Field of Sum then I can only guess that your Field
of Sum is not in the Record Source for the report.

--
Duane Hookom
MS Access MVP

Michel Ank said:
Hi Duane,

I'm using of this way, but when I sending the Report to Print, it's ask
me a parameter with Field of Sum.


Michel Ank

Duane Hookom escreveu:
What Rick is suggesting is to view your report's Footer section (not the
Page footer). Add a text box to the Report Footer and set its Control
Source
property to something like:
=Sum([YourNumericFieldName])

--
Duane Hookom
MS Access MVP

Michel Ank said:
Hi Rick,

Sorry, but I not understand.
Where I need makes a field?
Exist a way for me create this using VBA? I need to use a SUM in the
fields, because the report can will have a filter.

PS: I'm Braziliam and not speak in english right ok?

Thanks,
Michel


Rick Brandt escreveu:

Michel Ank wrote:
Hi all,

I have a field that your source is a Sql Query. I need show the sum
of
field in bottom of report, but =Sum([field]) not functions, because
your Source is a Query SQL. how to do?

thanks
Michel Ank

Sum(field) will work, but not in a page header or footer. You have to
use it in
a report header/footer or a group header/footer. Using a query,
table,
or SQL
statement as your RecordSource makes no difference at all.
Click to expand...
Click to expand...
Click to expand...
 
Hi Duane,

How I said, the Field isn't in Record Source. The Record Source of
Field is a Dlookup().


Regards,
Michel Ank

Duane Hookom escreveu:
If you are asked for the Field of Sum then I can only guess that your Field
of Sum is not in the Record Source for the report.

--
Duane Hookom
MS Access MVP

Michel Ank said:
Hi Duane,

I'm using of this way, but when I sending the Report to Print, it's ask
me a parameter with Field of Sum.


Michel Ank

Duane Hookom escreveu:
What Rick is suggesting is to view your report's Footer section (not the
Page footer). Add a text box to the Report Footer and set its Control
Source
property to something like:
=Sum([YourNumericFieldName])

--
Duane Hookom
MS Access MVP

Hi Rick,

Sorry, but I not understand.
Where I need makes a field?
Exist a way for me create this using VBA? I need to use a SUM in the
fields, because the report can will have a filter.

PS: I'm Braziliam and not speak in english right ok?

Thanks,
Michel


Rick Brandt escreveu:

Michel Ank wrote:
Hi all,

I have a field that your source is a Sql Query. I need show the sum
of
field in bottom of report, but =Sum([field]) not functions, because
your Source is a Query SQL. how to do?

thanks
Michel Ank

Sum(field) will work, but not in a page header or footer. You have to
use it in
a report header/footer or a group header/footer. Using a query,
table,
or SQL
statement as your RecordSource makes no difference at all.
Click to expand...
Click to expand...
Click to expand...
 
Where did the DLookup() come from? You can't sum an expression that isn't in
your report's record source.

Can you please tell us what you are working with and what you expect
displayed in the report? I feel like I am walking around trying to find my
way around a strange place in total darkness.

--
Duane Hookom
MS Access MVP

Michel Ank said:
Hi Duane,

How I said, the Field isn't in Record Source. The Record Source of
Field is a Dlookup().


Regards,
Michel Ank

Duane Hookom escreveu:
If you are asked for the Field of Sum then I can only guess that your
Field
of Sum is not in the Record Source for the report.

--
Duane Hookom
MS Access MVP

Michel Ank said:
Hi Duane,

I'm using of this way, but when I sending the Report to Print, it's ask
me a parameter with Field of Sum.


Michel Ank

Duane Hookom escreveu:

What Rick is suggesting is to view your report's Footer section (not
the
Page footer). Add a text box to the Report Footer and set its Control
Source
property to something like:
=Sum([YourNumericFieldName])

--
Duane Hookom
MS Access MVP

Hi Rick,

Sorry, but I not understand.
Where I need makes a field?
Exist a way for me create this using VBA? I need to use a SUM in the
fields, because the report can will have a filter.

PS: I'm Braziliam and not speak in english right ok?

Thanks,
Michel


Rick Brandt escreveu:

Michel Ank wrote:
Hi all,

I have a field that your source is a Sql Query. I need show the
sum
of
field in bottom of report, but =Sum([field]) not functions,
because
your Source is a Query SQL. how to do?

thanks
Michel Ank

Sum(field) will work, but not in a page header or footer. You have
to
use it in
a report header/footer or a group header/footer. Using a query,
table,
or SQL
statement as your RecordSource makes no difference at all.
Click to expand...
Click to expand...
Click to expand...
 
Hi Duane,

I resolved the problem using the Field in Record Source.

Thanks for all!
Michel Ank

Duane Hookom escreveu:
Where did the DLookup() come from? You can't sum an expression that isn't in
your report's record source.

Can you please tell us what you are working with and what you expect
displayed in the report? I feel like I am walking around trying to find my
way around a strange place in total darkness.

--
Duane Hookom
MS Access MVP

Michel Ank said:
Hi Duane,

How I said, the Field isn't in Record Source. The Record Source of
Field is a Dlookup().


Regards,
Michel Ank

Duane Hookom escreveu:
If you are asked for the Field of Sum then I can only guess that your
Field
of Sum is not in the Record Source for the report.

--
Duane Hookom
MS Access MVP

Hi Duane,

I'm using of this way, but when I sending the Report to Print, it's ask
me a parameter with Field of Sum.


Michel Ank

Duane Hookom escreveu:

What Rick is suggesting is to view your report's Footer section (not
the
Page footer). Add a text box to the Report Footer and set its Control
Source
property to something like:
=Sum([YourNumericFieldName])

--
Duane Hookom
MS Access MVP

Hi Rick,

Sorry, but I not understand.
Where I need makes a field?
Exist a way for me create this using VBA? I need to use a SUM in the
fields, because the report can will have a filter.

PS: I'm Braziliam and not speak in english right ok?

Thanks,
Michel


Rick Brandt escreveu:

Michel Ank wrote:
Hi all,

I have a field that your source is a Sql Query. I need show the
sum
of
field in bottom of report, but =Sum([field]) not functions,
because
your Source is a Query SQL. how to do?

thanks
Michel Ank

Sum(field) will work, but not in a page header or footer. You have
to
use it in
a report header/footer or a group header/footer. Using a query,
table,
or SQL
statement as your RecordSource makes no difference at all.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top