" is not a valid name

[Guest]

I am trying to sum a list of values in a report. In the report footer I am
placing =Sum([RetirementExceptions1Query.RetirementMonth1Tbl.Contri]). When
I try to look at the report I get the error:

" is not a valid name. Make sure that it does not include invalid
characters or punctuation and that it is not too long.

If I take out the sum portion I get the first record. Does anyone know how
I can get the sum of the values?

Dena

 

['69 Camaro]

Hi, Dena.

I am trying to sum a list of values in a report. In the report footer I am
placing =Sum([RetirementExceptions1Query.RetirementMonth1Tbl.Contri]).
When
I try to look at the report I get the error:

" is not a valid name. Make sure that it does not include invalid
characters or punctuation and that it is not too long.

Actually, "RetirementExceptions1Query.RetirementMonth1Tbl.Contri" is not a
valid name in a Jet query, because it contains an invalid character. Only
one period may be used, and it must be placed between the name of the table
(or query) and the name of the column. The period right before "Contri"
shouldn't be there.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Douglas J. Steele]

Hi, Dena.

I am trying to sum a list of values in a report. In the report footer I
am
placing =Sum([RetirementExceptions1Query.RetirementMonth1Tbl.Contri]).
When
I try to look at the report I get the error:

" is not a valid name. Make sure that it does not include invalid
characters or punctuation and that it is not too long.

Actually, "RetirementExceptions1Query.RetirementMonth1Tbl.Contri" is not a
valid name in a Jet query, because it contains an invalid character. Only
one period may be used, and it must be placed between the name of the
table (or query) and the name of the column. The period right before
"Contri" shouldn't be there.

Actually, it looks to me like the table name is being included
inappropriately, and that the reference should be
RetirementExceptions1Query.Contri

 

['69 Camaro]

"Douglas J. Steele"

"'69 Camaro"

Hi, Dena.

I am trying to sum a list of values in a report. In the report footer I
am
placing =Sum([RetirementExceptions1Query.RetirementMonth1Tbl.Contri]).
When
I try to look at the report I get the error:

" is not a valid name. Make sure that it does not include invalid
characters or punctuation and that it is not too long.

Actually, "RetirementExceptions1Query.RetirementMonth1Tbl.Contri" is not
a valid name in a Jet query, because it contains an invalid character.
Only one period may be used, and it must be placed between the name of
the table (or query) and the name of the column. The period right before
"Contri" shouldn't be there.

Actually, it looks to me like the table name is being included
inappropriately, and that the reference should be
RetirementExceptions1Query.Contri

I can only speculate on how the table name got stuck in there. Half the
time I've seen it happen, Jet automatically put it in there in the query
designer. The other half the time, the user named the column with the
period as part of the name.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.