Rounding-down & IFs?

Article View: comp.databases.ms-access

Article #425

Back to comp.databases.ms-access Previous Next

#425

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

19 lines
1688 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.


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: <880514703.64503@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: 111a5a,9851c8d9c939c74c,start
X-Google-Attributes: gid111a5a,public
X-Google-Thread: ff0ac,9851c8d9c939c74c,start
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 102b1d,9851c8d9c939c74c,start
X-Google-Attributes: gid102b1d,public
X-Google-Thread: 10bb27,9851c8d9c939c74c,start
X-Google-Attributes: gid10bb27,public
X-Google-Thread: f8db2,9851c8d9c939c74c,start
X-Google-Attributes: gidf8db2,public
X-Google-Thread: 1143dd,9851c8d9c939c74c,start
X-Google-Attributes: gid1143dd,public
From: "Alan Steele" <asteele@welpac.com.au>
Subject: Rounding-down & IFs?
Date: 1997/11/26
Message-ID: <880514703.64503@comcen.comcen.com.au>
X-Deja-AN: 292720992
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