[AccessD] How to split a number...

James Button jamesbutton at blueyonder.co.uk
Wed Jul 20 14:31:45 CDT 2016


Ah! - I'm in Excel mode ! 

JimB

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of James
Button
Sent: Wednesday, July 20, 2016 8: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