Sum Of Column

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
 
D

Duane Hookom

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

Frank Wagner

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

Duane Hookom

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

Frank Wagner

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

Duane Hookom

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

Frank Wagner

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