Overflow Error Message

  • Thread starter Thread starter CC
  • Start date Start date
C

CC

Hi~
I saw the previous posting posted by WaterBrook- but I've
run an update and it did not work.

The query takes data from two other queries and a table.
I have the following formulas in the query:
QA Rep: IIf([Assigned QA Rep] Is Not Null,[Assigned QA
Rep],"No QA Rep Assigned")

1: Total Monitoring pts

2: Total Aval Monitoring pts

Overall Monitoring Score: [1]/[2]

I also have them "totaled" - group by - last - max etc...

Any suggestions. Thanks CC
 
I think the overflow error might occur when you try to assign data to a data
type that is beyond its capacity to handle. For example if you have a field
with a datatype of byte and try to assign a value higher that 255 you will
get an overflow error (please step in if I'm way off).
 
Thanks - you were on the right track - your reply
triggered me to look at the data and I found a calculation
(0/0) that caused "#Error" and when I tried to have that
field do a sum - it obviously can't sum a field that
contains #Error. Thanks so much for your posting! CC
-----Original Message-----
I think the overflow error might occur when you try to assign data to a data
type that is beyond its capacity to handle. For example if you have a field
with a datatype of byte and try to assign a value higher that 255 you will
get an overflow error (please step in if I'm way off).
Hi~
I saw the previous posting posted by WaterBrook- but I've
run an update and it did not work.

The query takes data from two other queries and a table.
I have the following formulas in the query:
QA Rep: IIf([Assigned QA Rep] Is Not Null,[Assigned QA
Rep],"No QA Rep Assigned")

1: Total Monitoring pts

2: Total Aval Monitoring pts

Overall Monitoring Score: [1]/[2]

I also have them "totaled" - group by - last - max etc...

Any suggestions. Thanks CC
Click to expand...


.
Click to expand...
 
Back
Top