Martian262002
New member
- Local time
- Today, 01:19
- Joined
- Apr 19, 2006
- Messages
- 7
Hello Everyone ,
In access, I have a field in a table that I need to fix. The field contains a charge(money) value, with a code attached to it. For example:
[2345.0020680]---> The (2345.00) is the charage amount & the (20680) is the code.
[17580.04PPO]----> (17580.04) is Charge; (PPO) is the code.
**Every charge amount is different, and every codes length is different; so there is no consistency in this field.
I need to add a space, comma, backslash, or something two places after the decimal, to split the two. Once I do that I'll export to excel, and split the field into 2.
HELP!
Thanks in advance everyone,
Martian262002
In access, I have a field in a table that I need to fix. The field contains a charge(money) value, with a code attached to it. For example:
[2345.0020680]---> The (2345.00) is the charage amount & the (20680) is the code.
[17580.04PPO]----> (17580.04) is Charge; (PPO) is the code.
**Every charge amount is different, and every codes length is different; so there is no consistency in this field.
I need to add a space, comma, backslash, or something two places after the decimal, to split the two. Once I do that I'll export to excel, and split the field into 2.
HELP!
Thanks in advance everyone,
Martian262002