Overflow Error Message

[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

 

[GPO]

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).

 

[CC]

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

.