Extracting part number (1 Viewer)

A

Andy P

New member
Local time
Today, 08:46
Joined
Aug 28, 2008
Messages
1
I am trying to build a formula using a part number
Example 3.6715 and only want to use the .6715 in my calculation. Any ideas how I can extract this?:confused:
 
KenHigg

KenHigg

Registered User
Local time
Today, 11:46
Joined
Jun 9, 2004
Messages
13,327
myNewNumber = MyOldNumber - int(MyOldNumber)

???
 
You must log in or register to reply here.

Similar threads

T
extracting data from the URL and then saving into MS Access table
2
Replies
21
Views
463
talha
T
S
count in access
Replies
15
Views
862
spinev
S
H
move an item from list box to another list box in one form
Replies
6
Views
485
MajP
MajP
B
Solved Extracting ONLY Numbers from a Field to be used for Sorting
Replies
3
Views
456
sxschech
S
A
Extracting the images in Access Image Gallery
2
Replies
36
Views
1,353
seemick
S

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Top Bottom