[AccessD] OT: Sum in MySQL

Gustav Brock Gustav at cactus.dk
Thu Nov 24 08:51:49 CST 2005


Hi all
I recall we have some MySQL gurus around ...

If you have a field of datatype Integer (Long in Access) and wish to sum this from a large amount of records, how would you do in MySQL?

In Access you would do something like:

  SELECT SUM(CDbl([FieldInteger])) FROM tblTable ...;

and the result would be a - potentially very large - Double.
What to use for CDbl() in MySQL?

/gustav




More information about the AccessD mailing list