[mso] Re: Access
- From: "Colli, Anthony G" <Anthony.Colli@xxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Mon, 3 Jun 2002 17:18:54 -0400
You could use a function to convert the numbers. Inside the function you
would need a Select Case statement. Is this being used in a query? or
something else?
Some cheesy example code
------------------------------------------------------------
Private Sub ConvertNumbers(in As integer) As Integer
Select Case in
Case 36
ConvertNumbers = 1600
Case 35
ConvertNumbers = 1580
Case 34
ConvertNumbers = 1520
ect....
end sub
------------------------------------------------------------
You can then write your query to return the value of ConvertNumbers(in)
-----Original Message-----
From: Glenda Wells [mailto:gwells@xxxxxxxxxxx]
Sent: Monday, June 03, 2002 5:05 PM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Access
I need to convert values in Access.
Example, 36 = 1600, 35 = 1580, 34 = 1520, 33 = 1470 etc. I tried nested IF,
but it only let me do 13 at a time. There are about 60. I'm reading about
Function Procedures, but it doesn't seem right.
Any advice appreciated.
gl
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions. Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
