How do I create a currency feild from a NZ function?

G

Guest

I have used the NZ functionin a query eg. (y2005: Nz([2005],"0"))to place a
zero in any records that do not have data, however the records that do now
return a number in text format rather than the original currency format.

How do I have the result stay in currency format?
 
G

Guest

Thanks, Works Great!

Stin

Van T. Dinh said:
y2005: CCur(Nz([2005],0))

--
HTH
Van T. Dinh
MVP (Access)


stinhop said:
I have used the NZ functionin a query eg. (y2005: Nz([2005],"0"))to place a
zero in any records that do not have data, however the records that do now
return a number in text format rather than the original currency format.

How do I have the result stay in currency format?
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nz Function 8
Query Field Format 2
NZ function 1
Nz Issue - changes cell to Text 9
IIF statement 6
Nz function 6
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Null value to "0" / Currency format 2

Top