Re: Rounding-down?

Article View: comp.databases.ms-access

Article #429

Back to comp.databases.ms-access Previous Next

#429

From: P.Valkenburg
Date: Wed, 26 Nov 1997 00:00

21 lines
1620 bytes

Use : OtherFieldName:Int([field to strip of the everything behind the dot])
in place of the original field name.

Alan Steele schreef:

> Hey,
> I'm in the process of inserting the Luhn algorithm (for basic credit card
> checking) into an existing database but 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.
>
> I am using the design view for the query but wouldn't be opposed to using
> SQL if someone should volunteer some SQL info.
>
> Thanks in advance,
>
> Alan Steele, Systems Admin.
> asteele@welpac.com.au

Technical Details

Message-ID: <347C6C99.32D0FDF7@No.Where>

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

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 111a5a,67898c0e33a2c2b2
X-Google-Attributes: gid111a5a,public
X-Google-Thread: 1143dd,67898c0e33a2c2b2
X-Google-Attributes: gid1143dd,public
X-Google-Thread: f8db2,67898c0e33a2c2b2
X-Google-Attributes: gidf8db2,public
X-Google-Thread: 102b1d,67898c0e33a2c2b2
X-Google-Attributes: gid102b1d,public
X-Google-Thread: 10bb27,67898c0e33a2c2b2
X-Google-Attributes: gid10bb27,public
X-Google-Thread: ff0ac,67898c0e33a2c2b2
X-Google-Attributes: gidff0ac,public
From: "P.Valkenburg" <No.One@No.Where>
Subject: Re: Rounding-down?
Date: 1997/11/26
Message-ID: <347C6C99.32D0FDF7@No.Where>
X-Deja-AN: 292928104
References: <880511701.177491@comcen.comcen.com.au>
Organization: Slave Labor Inc.
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