Convert text to numbet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all

I am building a query and would like to convert a text string to number

This is what I have thus far

NBR of Days Delinquent<90?: IIf([Delinquency Conversion to Num]<90,"y","n")

when I run the query it asking for the following

Enter Parameter Value

Delinquency Conversion to num

Please Help!!!!!!!!!!!!!!!!!!!!!!!!!!!!
 
That implies that you do not have a field named [Delinquency Conversion to
Num] in the underlying table(s).
 
I am building a query and would like to convert a text string to number
Click to expand...

Look up help for the CInt() or CDbl() functions. It works fine in VBA and
in SQL as long as you are talking to a jet database. If you have a SQL
Server database, then you'll need to check the CONVERT function but I
always have a horrendous time with that.

HTH


Tim F
 
Back
Top