I am trying to multiple a datbase integer by 100 and I get a dialog box that all it says is overflow. When I take the * 100 off the format, everything works fine but the number is not correct. My statement is as follows:
MyQualcost = IIf(IsNull(MyTable![Qualcost]), zeroes, Format(MyTable![Qualcost] * 100, "00000000000;"""))
MyQualcost is defined as an integer both within my VB code as well as the database. If my database fields is 123456, I need my extract record to be 12345600.
How do I get around the overflow error??? Thanks
MyQualcost = IIf(IsNull(MyTable![Qualcost]), zeroes, Format(MyTable![Qualcost] * 100, "00000000000;"""))
MyQualcost is defined as an integer both within my VB code as well as the database. If my database fields is 123456, I need my extract record to be 12345600.
How do I get around the overflow error??? Thanks