Access 2003 - Need to properly use Zoom in query design
Posted on 2009-03-29
I have a field named 1 in which the data is .0635438
At runtime of the query I need to convert that data to 63. I just can't seem to write the correct small algorithim in the Zoom area to accomplish that.
I wrote: 1: IIf(tblRptscores.1>0,Int([(tblRptscores.1]*100),"") and Access does not like that at all.
I also tried a couple of other ways, too, but they also failed the compile.
What is the right way to make that conversion? Please!