[AccessD] How to split a number...

Kaup, Chester Chester_Kaup at kindermorgan.com
Wed Jul 20 14:26:56 CDT 2016


What about something like this

Select Case X
	Case 0 to 15
		X * a
	Case 16 to 30
		X * b
	Case 31 to 60
		X * c
	Case 61 to 120
		X * d
	Case 121 to 180
		X * e
	Case 181 to 999
		X * f
	Case > 1000
		X * g
	Case Else
		"Error"
End Select

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kostas Konstantinidis
Sent: Wednesday, July 20, 2016 1:53 PM
To: 'Access Developers discussion and problem solving'
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



More information about the AccessD mailing list