string to number

[jozino01]

hi,
i am using the Nz() function in a query.
it works ok except that input data are numbers and results are strings.
how can i change the output from string back to number format, please?

 

[PHV]

Nz([numeric field],0)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jozino01]

well, if i use the results as input for another query it behaves as number format, but if i use it in access report or copy it to excel spreadsheet it behaves as string format (i mean both - values from [numeric field] and 0)

 

[PHV]

Have you applied a format to this field ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jozino01]

if i use format in the query it works (and it works on report too, not in excel - i cannot do math operations with it).

if i don't format query and use/select format only in report/field properties it doesn't.

 

[PHV]

And this ?
Val([numeric field] & "")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jozino01]

yes, it helps
thanks