By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,121 Members | 1,706 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,121 IT Pros & Developers. It's quick & easy.

How to fix "Overflow" errow when running a query in 2000 Access?

P: 1
I keep getting !Overflow error when running this query:
Expand|Select|Wrap|Line Numbers
  1. SELECT DISTINCTROW FamilyInfo.FamilyInfoID
  2.                  , Sum(IIf(IsNull(VitalPartnerCreditsQuery.VPCreditT),0,VitalPartnerCreditsQuery.VPCreditT)) AS TotVPCredit
  3. FROM VitalPartnerCreditsQuery RIGHT JOIN FamilyInfo ON VitalPartnerCreditsQuery.FamilyInfoID = FamilyInfo.FamilyInfoID
  4. GROUP BY FamilyInfo.FamilyInfoID;
Any help would be appreciated. Thx
Jan 20 '11 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,494
It doesn't make sense to use both DISTINCTROW and GROUP BY in the same SQL Tami.

Otherwise, there may well be an overflow from the data. We have too little information to comment further at this time.
Jan 21 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.