Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

OVERFLOW 2

Status
Not open for further replies.

sylvain

Technical User
Mar 20, 2001
39
0
0
CA
HI

Hope you can give me a clue on that

I receive an error message OVERFLOW when i tri to do a report with the following thing

*****************************************
Achats2000:[Achats 00]*12/[Prorata]
*****************************************

Thanks for your help
 
The Achats 00 is dollard Ex 12.28
We multiply that by 12 and then divide by a number between 1 and 12
 
I bet you have a zero value or a null somewhere... Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.
 
Try using achats 00 as something big, like a double, then converting it back to the desired type.
 
Thanks to all

There was a NULL value ....
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top