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).

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Chris" <(E-Mail Removed)> wrote in message
news:8F496226-B7FC-4889-A04E-(E-Mail Removed)...
> 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

=?Utf-8?B?Q2hyaXM=?= <(E-Mail Removed)> wrote in
news:8F496226-B7FC-4889-A04E-(E-Mail Removed):

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

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