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
>
|
View Cart
