Can i format text as a number in a query field?

[scottian]

how do i format this :-

(Right([TimeDivision],Len([TimeDivision])-2))*60

as a number?

i tried Format( (Right([TimeDivision],Len([TimeDivision])-2))*60) as integer

but it didnt work

"Children are smarter than any of us. Know how I know that? I don't know one child with a full time job and children."...Bill Hicks

 

[JoeAtWork]

Perhaps

CInt((Right([TimeDivision],Len([TimeDivision])-2)))*60

 

[scottian]

Thanks for the speedy response mate, but i get

#Error

CInt(Right([TimeDivision],Len([TimeDivision])-2))

"Children are smarter than any of us. Know how I know that? I don't know one child with a full time job and children."...Bill Hicks

 

[PHV]

What about this ?
Val(Mid([TimeDivision],3))

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[scottian]

Sorry JoeAtWork, PHV but still dont get the right answer

I need to multiply this ;-
0.883333333333333 by 60

and get 5.3E+16

but i should get 53.

"Children are smarter than any of us. Know how I know that? I don't know one child with a full time job and children."...Bill Hicks

 

[PHV]

Use this:
CInt(0.88333333333333 * 60)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886