Rounding-down?

Thread View: comp.databases.ms-access

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Alan Steele Wed, 26 Nov 1997 00:00

#424

Author: 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

Re: Rounding-down?

#429

Author: 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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads