Rounding-down?

Article View: comp.databases.ms-access

Article #424

Back to comp.databases.ms-access Previous Next

#424

From: Alan Steele
Date: Wed, 26 Nov 1997 00:00

16 lines
1567 bytes

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: <880511701.177491@comcen.comcen.com.au>

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f8db2,67898c0e33a2c2b2,start
X-Google-Attributes: gidf8db2,public
X-Google-Thread: 111a5a,67898c0e33a2c2b2,start
X-Google-Attributes: gid111a5a,public
X-Google-Thread: 1143dd,67898c0e33a2c2b2,start
X-Google-Attributes: gid1143dd,public
X-Google-Thread: 102b1d,67898c0e33a2c2b2,start
X-Google-Attributes: gid102b1d,public
X-Google-Thread: 10bb27,67898c0e33a2c2b2,start
X-Google-Attributes: gid10bb27,public
X-Google-Thread: ff0ac,67898c0e33a2c2b2,start
X-Google-Attributes: gidff0ac,public
From: "Alan Steele" <asteele@welpac.com.au>
Subject: Rounding-down?
Date: 1997/11/26
Message-ID: <880511701.177491@comcen.comcen.com.au>
X-Deja-AN: 292713126
Cache-Post-Path: comcen.comcen.com.au!unknown@modem100.ts2.crafti.com.au
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Organization: Welpac
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