This bid is for assistance with a SQL server query. I'm trying to use the SUM function to get totals from a column. The column has 15 rows. The row consists of negative and positive numbers. When I sum the rows... I receive a high exponent based value (-1.818989E-12) instead of (0).
I have attached a sample MSAccess 2000 database with the records and a query with the results.
Note: Keep in mind my field in SQL server is datatype (float) and length (8).
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
SQL Server 2000