p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: SUM aggregate function


Message #1 by jose@n... on Thu, 14 Jun 2001 20:16:55
I'm using the SUM aggregate function to add all the values of a column in 

a table from an Access database, but the result is blank. The type of 

field in the table is "text". Should it be "number"? I'm I doing anything 

wrong. The syntax is perfect. Thanks. 



Message #2 by "Simon Woollard" <simon.woollard@b...> on Thu, 14 Jun 2001 20:25:22 +0100
Hi:



Definitely try 'number' as the type. The SUM function will not aggregate

text.



Regards,



Simon

-----Original Message-----

From: jose@n... [mailto:jose@n...]

Sent: 14 June 2001 20:17

To: Access

Subject: [access] SUM aggregate function





I'm using the SUM aggregate function to add all the values of a column in

a table from an Access database, but the result is blank. The type of

field in the table is "text". Should it be "number"? I'm I doing anything

wrong. The syntax is perfect. Thanks.



Message #3 by "Darron Michael" <darron.michael@h...> on Fri, 15 Jun 2001 14:31:24
You might also try using. . .



sum(cdbl([textfieldname]))



cdbl converts text to a double.

cint converts text to an integer.



8^)



Darron
Message #4 by Jose Fernandez <jose@n...> on Tue, 19 Jun 2001 11:29:21 -0400
Sorry, Didn't work. I going to change the field from text to number.



Thanks





At 02:31 PM 6/15/2001 +0000, you wrote:

>You might also try using. . .

>

>sum(cdbl([textfieldname]))

>

>cdbl converts text to a double.

>cint converts text to an integer.

>

>8^)

>

>Darron

>


  Return to Index