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

S

stinhop

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?
 
S

stinhop

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