D
D Smith
I need to convert packed numbers into "real" numbers.
Packed numbers have no decimal places and the right-most digit is replace by
a character (A - R and { & } ) which determines the value (plus/minus).
ie:
1009J = -100.91
2543G = 354.37
{ = 0 } = -0
A = 1 J = -1
B = 2 K = -2 etc...
I've built queries that do a table lookup to convert this but it's kind of a
pain.
I would like to write a Module to do this so I can use it in directly in a
query.
I guess my real problem is that I don't know where to begin when creating a
Module.
Anybody care to tutor me (and probably a whole lot of others) on this?
Thanks!
Dave
Packed numbers have no decimal places and the right-most digit is replace by
a character (A - R and { & } ) which determines the value (plus/minus).
ie:
1009J = -100.91
2543G = 354.37
{ = 0 } = -0
A = 1 J = -1
B = 2 K = -2 etc...
I've built queries that do a table lookup to convert this but it's kind of a
pain.
I would like to write a Module to do this so I can use it in directly in a
query.
I guess my real problem is that I don't know where to begin when creating a
Module.
Anybody care to tutor me (and probably a whole lot of others) on this?
Thanks!
Dave