Access 2003 - Need to properly use Zoom in query design

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!
Who is Participating?
Patrick MatthewsConnect With a Mentor Commented:
BTW, it is a bad, bad, bad idea to use a number for a column name :)
Patrick MatthewsCommented:
IIf([tblRptscores].[1] > 0, Int([tblRptscores].[1] * 100), "")
ljcorAuthor Commented:
Thanks Patrick.  And I promise (really) never to use a number for a field again.  I don't even know what possessed me that time - and I have to many fields in that table and don't want to go back and change them all now.  Perhaps I will have to - but we'll see.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.