Solved

Overflow error

Posted on 2011-09-15
3
361 Views
Last Modified: 2012-05-12
I keep getting an overflow error on a the below:

SELECT Query1.RCTrack, Query1.RCDate, Query1.RCRace, Query1.Horse, Sum(Query1.RCWT) AS SumOfRCWT, Sum(Query1.NFIN) AS SumOfNFIN, Sum(Query1.RWNF) AS SumOfRWNF, Sum(Query1.RWBEYER) AS SumOfRWBEYER, Sum(Query1.AdjBeyer1) AS SumOfAdjBeyer1, Sum(Query1.AdjBeyer) AS SumOfAdjBeyer, Sum(Query1.NFC) AS SumOfNFC, Sum(Query1.RWFC) AS SumOfRWFC, Sum(Query1.SPEED) AS SumOfSPEED, Sum(Query1.NODDS) AS SumOfNODDS, Sum(Query1.RWOP) AS SumOfRWOP, Sum(Query1.RWSP) AS SumOfRWSP, Sum(Query1.RWPUR) AS SumOfRWPUR, Sum(Query1.RWWT) AS SumOfRWWT, Sum(Query1.RWDST) AS SumOfRWDST, Sum(Query1.NPOST) AS SumOfNPOST, Sum(Query1.ADJLENS) AS SumOfADJLENS, Sum(Query1.RWFINLENS) AS SumOfRWFINLENS INTO [SUMS OF FACTORS]
FROM Query1
GROUP BY Query1.RCTrack, Query1.RCDate, Query1.RCRace, Query1.Horse;


There are 712,000 rows in this.  This is Tracks G through I.  In tracks A through B, I did not get an overflow with the same code.  A through B has 1,310, 000 rows.

0
Comment
Question by:JackJackson54
  • 2
3 Comments
 
LVL 13

Accepted Solution

by:
LIONKING earned 500 total points
Comment Utility
It appears that it's not because of the rows, but my initial guess would be that one of the fields doesn't support the number that the SUM function is returning...

Have you tried casting your fields to larger values? What are the original field types?
0
 

Author Comment

by:JackJackson54
Comment Utility
'

They all are double because of decimals
0
 
LVL 13

Expert Comment

by:LIONKING
Comment Utility
Mmm... Maybe casting them as decimals could help...
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
This collection of functions covers all the normal rounding methods of just about any numeric value.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now