CALCULATION NOT WORKING TO SUM FIELDS

[Guest]

I AM TRYING TO TAKE AND ADD UP SEVERAL FIELDS FOR A SPECIFIC ACCT # AND IT'S
GIVING ME AN ERROR THAT MY QUERY DOES NOT CONTAIN THE EXPRESSION TOTAL AS
PART OF THE AGGREGATE FUNCTION.

I AM TRYING TO ADD(IE. FEE1, FEE2, FEE3, ETC) AND HAVE IT UPDATE THE TOTAL
FIELD.

 

[Guest]

Hi Chari

It seems your relationship may be a little out either between the tables or
in the design grid of your query.

Try this
Total:Sum(Nz([TableName]![FEE1]+Nz([TableName])![FEE2]+Nz([TableName]![FEE3])

If this does not work (I have assumed that all the tables are actually in
the grid) look at the relationships between the tables - click the linking
line between them to ensure that you have it right.

 

[Guest]

IT IS ALL IN 1 TABLE. I AM PUTTING THIS IN THE CRITERIA LINE AND STILL
GETTING AN ERROR MESSAGE OF INVALID OPERATOR OR PARENTHESES

TOTAL:SUM(NZ([FEE TEST 100206]![FEE1]+NZ([FEE TEST 100206]![FEE2]))

 

[Douglas J. Steele]

Tables don't use ! as an operator, they use .

Try

TOTAL:SUM(NZ([FEE TEST 100206].[FEE1]+NZ([FEE TEST 100206].[FEE2]))


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

IT IS ALL IN 1 TABLE. I AM PUTTING THIS IN THE CRITERIA LINE AND STILL
GETTING AN ERROR MESSAGE OF INVALID OPERATOR OR PARENTHESES

TOTAL:SUM(NZ([FEE TEST 100206]![FEE1]+NZ([FEE TEST 100206]![FEE2]))

I AM TRYING TO TAKE AND ADD UP SEVERAL FIELDS FOR A SPECIFIC ACCT # AND
IT'S
GIVING ME AN ERROR THAT MY QUERY DOES NOT CONTAIN THE EXPRESSION TOTAL AS
PART OF THE AGGREGATE FUNCTION.

I AM TRYING TO ADD(IE. FEE1, FEE2, FEE3, ETC) AND HAVE IT UPDATE THE
TOTAL
FIELD.

 

[Guest]

ooops


--
Wayne
Manchester, England.
Enjoy whatever it is you do

Tables don't use ! as an operator, they use .

Try

TOTAL:SUM(NZ([FEE TEST 100206].[FEE1]+NZ([FEE TEST 100206].[FEE2]))


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

IT IS ALL IN 1 TABLE. I AM PUTTING THIS IN THE CRITERIA LINE AND STILL
GETTING AN ERROR MESSAGE OF INVALID OPERATOR OR PARENTHESES

TOTAL:SUM(NZ([FEE TEST 100206]![FEE1]+NZ([FEE TEST 100206]![FEE2]))

I AM TRYING TO TAKE AND ADD UP SEVERAL FIELDS FOR A SPECIFIC ACCT # AND
IT'S
GIVING ME AN ERROR THAT MY QUERY DOES NOT CONTAIN THE EXPRESSION TOTAL AS
PART OF THE AGGREGATE FUNCTION.

I AM TRYING TO ADD(IE. FEE1, FEE2, FEE3, ETC) AND HAVE IT UPDATE THE
TOTAL
FIELD.