🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.databases.ms-access
Article #338

Re: Rounding problems with Access

#338
From: Robert A. Bowman
Date: Thu, 15 Jul 1999 00:00
30 lines
1998 bytes
The problem is in your data typing.  Floating point data types (single, double)
will not give you the results you want.  Use Currency instead.

Cheers,

Bob Bowman

Larry LeBlanc wrote:

> Good day,
>
> Can anyone explain to me why the following source code:
>
> Does anyone know of a Microsoft KnowledgeBase article that can help me with
> this problem?  In addition to posting a follow-up to this problem, can you
> please e-mail me directly (mailto:larry.leblanc@sympatico.ca) as I cannot
> follow this newsgroup.
>
> TIA,
>
> Larry
> --
> ===================================================================
> Larry LeBlanc, CNE-3
> Montreal, Quebec, CANADA
> mailto:larry.leblanc@sympatico.ca     (flames directed to /dev/null)
> -------------------------------------------------------------------
> This message was compiled and sent using environmentally friendly
> recycled electrons and was not tested on animals.
> ===================================================================
Technical Details
Message-ID: <378DF0D4.412CD0BA@emx.ericsson.se>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <wQkj3.4$PZ3.247@198.235.216.4>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 111a5a,73518ce6c7069b00
X-Google-Attributes: gid111a5a,public
X-Google-Thread: 1131f0,73518ce6c7069b00
X-Google-Attributes: gid1131f0,public
X-Google-Thread: ff0ac,73518ce6c7069b00
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 102b1d,73518ce6c7069b00
X-Google-Attributes: gid102b1d,public
From: "Robert A. Bowman" <rbowman@emx.ericsson.se>
Subject: Re: Rounding problems with Access
Date: 1999/07/15
Message-ID: <378DF0D4.412CD0BA@emx.ericsson.se>
X-Deja-AN: 501340173
Content-Transfer-Encoding: 7bit
References: <wQkj3.4$PZ3.247@198.235.216.4>
To: Larry LeBlanc <larry.leblanc@sympatico.ca>
X-Accept-Language: en,fr,it
Content-Type: text/plain; charset=us-ascii
Organization: Ericsson Messaging Systems Inc.
Mime-Version: 1.0
Reply-To: rbowman@emx.ericsson.se
Newsgroups: comp.databases.ms-access,de.comp.datenbanken.ms-access,es.comp.bd.ms-access,microsoft.public.access.modulesdaovba