Solved

Access 2003 - Need to properly use Zoom in query design

Posted on 2009-03-29
3
360 Views
Last Modified: 2013-11-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!
0
Comment
Question by:ljcor
  • 2
3 Comments
 
LVL 92

Expert Comment

by:Patrick Matthews
ID: 24013196
IIf([tblRptscores].[1] > 0, Int([tblRptscores].[1] * 100), "")
0
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 500 total points
ID: 24013199
BTW, it is a bad, bad, bad idea to use a number for a column name :)
0
 

Author Closing Comment

by:ljcor
ID: 31564052
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Running sum query 6 32
MS Access Tables Linking 6 42
access 7 25
Access coding 2 11
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now