"Overflow" Error in Totals Query

[Alice]

I am trying to create a Query (call it Query1) that
calculates the Total of the field "Current BI Prem", and
grouped by a field called "Range". But it gives me
an "overflow" error.

The SQL for Query1 is:
SELECT combined.range, Sum(combined.[Current BI Prem]) AS
[SumOfCurrent BI Prem]
FROM combined
GROUP BY combined.range;

The result of Query1 should look like:
range SumOfCurrent BI Prem
A)-100%<x<-20% 0
B)-20%<x<-15% 0
C)-15%<x<-10% 0
D)-10%<x<-0.1% 1071166
E)-0.1%<x<+0.1% 92354
F)+0.1%<x<+10% 3763472
G)+10%<x<+15% 409758
H)+15%<x<+20% 237522
I)+20%<x 345916

In Query1, I used the query "combined", which has the
fields "range", "Current BI Prem" etc.

When I try to run the query "combined" as a "make-table
query", and create a table called "combine". And then add
the table "combine" in Query1 instead of the
query "combined". Query1 worked.

But I really don't want to run "combined" as a "make-table
query first", and then run my Query1. I just want to add
the query "combined" into Query1. Can anyone please help
me?

Thanks a lot,

Alice
..

 

[[MVP] S. Clark]

Overflow typically occurs do the fact that the recepient field's data type
is not large enough to accept the value. For instance, an integer can only
handle numbers up to 32,768, and a byte, only 255.

Check your datatypes and see if this is the problem.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-