[AccessD] How to split a number...

Kostas Konstantinidis kost36 at otenet.gr
Wed Jul 20 14:53:03 CDT 2016


James and Kaup,
May be I was no so specific
Actually I need first  to separate the fixed number 999  in 6 fixed groups
like
15
15
30
60
60
819
-----
999

If >1000*g

And then to calculate with (a-g)


Sorry
/kostas


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
James Button
Sent: Wednesday, July 20, 2016 10:08 PM
To: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] How to split a number...

If
(x<0,"Ooh",if(x>1000,g,if(x>=181,f,choose(int(x/15),a,b,c,c,d,d,d,d,e,e,e,e)
)))

Note - you don't indicate if the value is integer, or float  or has any
other limitations

JimB

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Kostas Konstantinidis
Sent: Wednesday, July 20, 2016 7:53 PM
To: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Subject: [AccessD] How to split a number...

Hi all,
I have a number and what I need is first to split it in the follow parts and
then to calculate as
0-15 *a
16-30 *b
31-60*c
61-120*d
121-180*e
181-999*f
>1000*g

(a - g) are different values

Any help please?
Thank's
/kostas

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list