Convert String to number

djai695

Registered User.
Local time
Today, 05:03
Joined
Dec 13, 2013
Messages
21
Does anyone know how I can convert the first column to show the number? I used the expression below, but it does not convert anything with a letter or a 0

Expr1: Val([SPPC TEST]![JULY_ACCRUAL_ADJ_X])

Query.JPG
 
What does this JULY_ACCRUAL_ADJ_X represent in business terms?
Do you get this from a mainframe or possibly some EBCDIC source?
You may wish to research zoned ASCII.

Good luck.
 
The field comes from a data table which I am pulling from with Access.
 
Where does the data originate? AS400? Mainframe?
What does 000000000J represent in business terms?? I realize your're "pulling it" from somewhere but what is it in business terms --- quantityOnHand, AmountOwed, PackageNumber??????
 
the main table which contains this field is coming from the mainframe (PDB2), the field itself in business terms represents a numeric value used for rounding.

If someone enters a spending plan total amount on the screen of the actual program, they use the field to put a small amount such as -1 or 2 or 3 to get to the exact total.
 

Users who are viewing this thread

Back
Top Bottom