Re: Rounding-down & IFs?

Article View: comp.databases.ms-access

Article #427

Back to comp.databases.ms-access Previous Next

#427

From: Allan Bertelsen
Date: Wed, 26 Nov 1997 00:00

34 lines
1999 bytes

Formating a field does not remove decimals, it just shows the number in
another way. 
To solve the problem you use a formula in a query. If the field's name is
Number, 
you create a calculated field named NewNumber by the statment:

NewNumber: Int([Number])

The If-statement is used in a similar way:

Tax: If([Value]>0 , [Value]*0.5 , 0)

The field Tax is 50% of Value if Value is positive.

Allan Bertelsen
WM-Data BFC
Denmark

Alan Steele <asteele@welpac.com.au> wrote
<880514703.64503@comcen.comcen.com.au>...
> Hey,
> ... I'm having some problems removing the decimal places after performing

> one of the calculations.
> 
> I've tried formatting to "0" and using "0" decimal places, both of which
> round the number up.
> 
> The other question I have is on how to use "If" statements within a
query?
> Any help would be much appreciated. Thanks in advance,
> Alan Steele, Systems Admin.
> asteele@welpac.com.au

Technical Details

Message-ID: <01bcfa54$3cbc46e0$f30211ac@ABKOLKUR>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <880514703.64503@comcen.comcen.com.au>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 111a5a,9851c8d9c939c74c
X-Google-Attributes: gid111a5a,public
X-Google-Thread: f8db2,9851c8d9c939c74c
X-Google-Attributes: gidf8db2,public
X-Google-Thread: ff0ac,9851c8d9c939c74c
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 10bb27,9851c8d9c939c74c
X-Google-Attributes: gid10bb27,public
X-Google-Thread: 102b1d,9851c8d9c939c74c
X-Google-Attributes: gid102b1d,public
X-Google-Thread: 1143dd,9851c8d9c939c74c
X-Google-Attributes: gid1143dd,public
From: "Allan Bertelsen" <alb@bfc.dk>
Subject: Re: Rounding-down & IFs?
Date: 1997/11/26
Message-ID: <01bcfa54$3cbc46e0$f30211ac@ABKOLKUR>
X-Deja-AN: 292807026
References: <880514703.64503@comcen.comcen.com.au>
X-Complaints-To: usenet@news.dknet.dk
X-Trace: news.dknet.dk 880539311 16624 (None) 194.192.110.10
Organization: WM-data BFC A/S
Newsgroups: comp.databases.ms-access,de.comp.datenbanken.ms-access,es.comp.bd.ms-access,it.comp.database.access,microsoft.public.access.chat,microsoft.public.access.queries

Reply to Parent Message