• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 369
  • 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

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

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