Sum Of Column

  • Thread starter Thread starter Frank Wagner
  • Start date Start date
F

Frank Wagner

I have a detail control named YToD on a tabulating report
with several rows and columns. In the Report Footer at
the bottom of the report, I want to sum the column with
the YToD control for all rows. When I enter the
expression Sum([YToD]) in the Report Footer control,
I get the error message "The Jet engine does not
recognize '[YToD]' as a valid field name or expression".

I must be doing something very basic that is wrong. Any
help would be appreciated.

Frank Wagner
 
Make sure you are doing this in the Report Footer, not the Page Footer.
Also, this all assumes you have a field in your report's recordsource named
YToD.
 
Duane:

The control is definitely in the Report Footer.

YToD, however, is the name of a control I created on the
right side of the detail section of the report which
summarizes all controls on the left with the formula (=Nz
([Column1], 0) + Nz([Column2], 0) etc). It is a
calculated control, not a value from the source query.

The sum I am trying to create with =Sum([YtoD]) is a
total for the value of the YToD control for all the rows
of the report.

I just keep getting the error message.

Frank Wagner

-----Original Message-----
Make sure you are doing this in the Report Footer, not the Page Footer.
Also, this all assumes you have a field in your report's recordsource named
YToD.

--
Duane Hookom
MS Access MVP
--

Frank Wagner said:
I have a detail control named YToD on a tabulating report
with several rows and columns. In the Report Footer at
the bottom of the report, I want to sum the column with
the YToD control for all rows. When I enter the
expression Sum([YToD]) in the Report Footer control,
I get the error message "The Jet engine does not
recognize '[YToD]' as a valid field name or expression".

I must be doing something very basic that is wrong. Any
help would be appreciated.

Frank Wagner
Click to expand...


.
Click to expand...
 
You can't sum a control. You can usually sum the Control Source of a
control:
=Sum(Nz([Column1], 0) + Nz([Column2], 0) etc)
Looking back at your other thread(s), I think I suggested that you create
the Sum as a Row heading in your crosstab query. You never responded to
either reply in that thread.

--
Duane Hookom
MS Access MVP


Frank Wagner said:
Duane:

The control is definitely in the Report Footer.

YToD, however, is the name of a control I created on the
right side of the detail section of the report which
summarizes all controls on the left with the formula (=Nz
([Column1], 0) + Nz([Column2], 0) etc). It is a
calculated control, not a value from the source query.

The sum I am trying to create with =Sum([YtoD]) is a
total for the value of the YToD control for all the rows
of the report.

I just keep getting the error message.

Frank Wagner

-----Original Message-----
Make sure you are doing this in the Report Footer, not the Page Footer.
Also, this all assumes you have a field in your report's recordsource named
YToD.

--
Duane Hookom
MS Access MVP
--

Frank Wagner said:
I have a detail control named YToD on a tabulating report
with several rows and columns. In the Report Footer at
the bottom of the report, I want to sum the column with
the YToD control for all rows. When I enter the
expression Sum([YToD]) in the Report Footer control,
I get the error message "The Jet engine does not
recognize '[YToD]' as a valid field name or expression".

I must be doing something very basic that is wrong. Any
help would be appreciated.

Frank Wagner
Click to expand...


.
Click to expand...
Click to expand...
 
Duane:

Thanks for responding. I ended up using the Sum(Nz
[Column1],0) etc solution on the first issue as to how to
sum the columns in a row because one of the items in my
cross tab query was not included in the total, and I
couldn't figure out how to total all the items in the
query except one.

With regard to the current issue of how to sum the rows
in a column, I didn't know that I couldn't sum a control,
and now I do, thanks to you.

The solution I finally used on the current problem was to
forget about summing the rows in the column, and used the
Sum(Nz[Column1],0), etc procedure to sum the columns in
the Report Footer row.

Thanks for the help. I'm learning as I go, when it comes
to reports, and this newsgroup is the only thing that
keeps me going.

Thanks Again

Frank Wagner
-----Original Message-----
You can't sum a control. You can usually sum the Control Source of a
control:
=Sum(Nz([Column1], 0) + Nz([Column2], 0) etc)
Looking back at your other thread(s), I think I suggested that you create
the Sum as a Row heading in your crosstab query. You never responded to
either reply in that thread.

--
Duane Hookom
MS Access MVP


Frank Wagner said:
Duane:

The control is definitely in the Report Footer.

YToD, however, is the name of a control I created on the
right side of the detail section of the report which
summarizes all controls on the left with the formula (=Nz
([Column1], 0) + Nz([Column2], 0) etc). It is a
calculated control, not a value from the source query.

The sum I am trying to create with =Sum([YtoD]) is a
total for the value of the YToD control for all the rows
of the report.

I just keep getting the error message.

Frank Wagner

-----Original Message-----
Make sure you are doing this in the Report Footer, not the Page Footer.
Also, this all assumes you have a field in your
Click to expand...
report's
recordsource named
YToD.

--
Duane Hookom
MS Access MVP
--

I have a detail control named YToD on a tabulating report
with several rows and columns. In the Report Footer at
the bottom of the report, I want to sum the column with
the YToD control for all rows. When I enter the
expression Sum([YToD]) in the Report Footer control,
I get the error message "The Jet engine does not
recognize '[YToD]' as a valid field name or expression".

I must be doing something very basic that is wrong. Any
help would be appreciated.

Frank Wagner


.
Click to expand...
Click to expand...


.
Click to expand...
 
To exclude one of the columns from a derived columns in a crosstab... assume
column headings of employees' first names. Now assume you want to sum their
salaries except for John because he will soon be fired. Your Row Heading
would be

Field: AllSalsButJohn: Abs([FirstName]<>"John") * [Salary]
Total: Sum
Xtab: Row Heading

--
Duane Hookom
MS Access MVP


Frank Wagner said:
Duane:

Thanks for responding. I ended up using the Sum(Nz
[Column1],0) etc solution on the first issue as to how to
sum the columns in a row because one of the items in my
cross tab query was not included in the total, and I
couldn't figure out how to total all the items in the
query except one.

With regard to the current issue of how to sum the rows
in a column, I didn't know that I couldn't sum a control,
and now I do, thanks to you.

The solution I finally used on the current problem was to
forget about summing the rows in the column, and used the
Sum(Nz[Column1],0), etc procedure to sum the columns in
the Report Footer row.

Thanks for the help. I'm learning as I go, when it comes
to reports, and this newsgroup is the only thing that
keeps me going.

Thanks Again

Frank Wagner
-----Original Message-----
You can't sum a control. You can usually sum the Control Source of a
control:
=Sum(Nz([Column1], 0) + Nz([Column2], 0) etc)
Looking back at your other thread(s), I think I suggested that you create
the Sum as a Row heading in your crosstab query. You never responded to
either reply in that thread.

--
Duane Hookom
MS Access MVP


Frank Wagner said:
Duane:

The control is definitely in the Report Footer.

YToD, however, is the name of a control I created on the
right side of the detail section of the report which
summarizes all controls on the left with the formula (=Nz
([Column1], 0) + Nz([Column2], 0) etc). It is a
calculated control, not a value from the source query.

The sum I am trying to create with =Sum([YtoD]) is a
total for the value of the YToD control for all the rows
of the report.

I just keep getting the error message.

Frank Wagner


-----Original Message-----
Make sure you are doing this in the Report Footer, not
the Page Footer.
Also, this all assumes you have a field in your report's
recordsource named
YToD.

--
Duane Hookom
MS Access MVP
--

I have a detail control named YToD on a tabulating
report
with several rows and columns. In the Report Footer at
the bottom of the report, I want to sum the column with
the YToD control for all rows. When I enter the
expression Sum([YToD]) in the Report Footer
control,
I get the error message "The Jet engine does not
recognize '[YToD]' as a valid field name or
expression".

I must be doing something very basic that is wrong.
Any
help would be appreciated.

Frank Wagner


.
Click to expand...


.
Click to expand...
Click to expand...
 
Duane: Thanks. The query part had me stumped. Got it
now.

Thanks Again

Frank Wagner
-----Original Message-----
To exclude one of the columns from a derived columns in a crosstab... assume
column headings of employees' first names. Now assume you want to sum their
salaries except for John because he will soon be fired. Your Row Heading
would be

Field: AllSalsButJohn: Abs([FirstName]<>"John") * [Salary]
Total: Sum
Xtab: Row Heading

--
Duane Hookom
MS Access MVP


Frank Wagner said:
Duane:

Thanks for responding. I ended up using the Sum(Nz
[Column1],0) etc solution on the first issue as to how to
sum the columns in a row because one of the items in my
cross tab query was not included in the total, and I
couldn't figure out how to total all the items in the
query except one.

With regard to the current issue of how to sum the rows
in a column, I didn't know that I couldn't sum a control,
and now I do, thanks to you.

The solution I finally used on the current problem was to
forget about summing the rows in the column, and used the
Sum(Nz[Column1],0), etc procedure to sum the columns in
the Report Footer row.

Thanks for the help. I'm learning as I go, when it comes
to reports, and this newsgroup is the only thing that
keeps me going.

Thanks Again

Frank Wagner
-----Original Message-----
You can't sum a control. You can usually sum the
Click to expand...
Control
Source of a
control:
=Sum(Nz([Column1], 0) + Nz([Column2], 0) etc)
Looking back at your other thread(s), I think I suggested that you create
the Sum as a Row heading in your crosstab query. You never responded to
either reply in that thread.

--
Duane Hookom
MS Access MVP


Duane:

The control is definitely in the Report Footer.

YToD, however, is the name of a control I created on the
right side of the detail section of the report which
summarizes all controls on the left with the formula (=Nz
([Column1], 0) + Nz([Column2], 0) etc). It is a
calculated control, not a value from the source query.

The sum I am trying to create with =Sum([YtoD]) is a
total for the value of the YToD control for all the rows
of the report.

I just keep getting the error message.

Frank Wagner


-----Original Message-----
Make sure you are doing this in the Report Footer, not
the Page Footer.
Also, this all assumes you have a field in your report's
recordsource named
YToD.

--
Duane Hookom
MS Access MVP
--

I have a detail control named YToD on a tabulating
report
with several rows and columns. In the Report
Click to expand...
Footer
at
the bottom of the report, I want to sum the column with
the YToD control for all rows. When I enter the
expression Sum([YToD]) in the Report Footer
control,
I get the error message "The Jet engine does not
recognize '[YToD]' as a valid field name or
expression".

I must be doing something very basic that is wrong.
Any
help would be appreciated.

Frank Wagner


.



.
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top