How to Change a result (1 Viewer)

icedearth

Registered User.
Local time
Today, 18:41
Joined
Oct 10, 2008
Messages
24
To whom may concern

I would like to know how to change a result that comes in txt formatting to numeric formatting. I'm using a query that i used this field Expr1: Right([DBA_INC_LOAN_BANK]![BRANCH_NUMBER],3) that could gave what i want, so it gave me what i want but in txt formatting.
 

KenHigg

Registered User
Local time
Today, 17:41
Joined
Jun 9, 2004
Messages
13,327
You could use one of the conversion functions like cdbl() -

???
 

Users who are viewing this thread

Top Bottom