• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 375
  • Last Modified:

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!
0
ljcor
Asked:
ljcor
  • 2
1 Solution
 
Patrick MatthewsCommented:
IIf([tblRptscores].[1] > 0, Int([tblRptscores].[1] * 100), "")
0
 
Patrick MatthewsCommented:
BTW, it is a bad, bad, bad idea to use a number for a column name :)
0
 
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.
0
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now