Nz and Formats

[Guest]

Hi,

I have a form based on a query that takes data (Numbers stored as doubles)
from several other queries and adds them up. Not all data is in all tables so
I've used Nz to make sure something shows up in each field as the related
records are displayed. Sort of like this:

EQUIPFINAL: Nz(FCNCostQuery![Sum Of TOTALEQUIPCOST],0)

for an individual field and something like this for the aggregate:

FinalFCNCost: Nz(POPercentagestoFCNQuery!POtoFCN,0)+Nz(FCNCostQuery![Sum Of
TOTALEQUIPCOST],0)+Nz(FCNCostQuery![Sum Of TOTALLABORCOST],0)

Because I am showing costs, I'd like to display the results in a currency
format. The aggregate works fine, but the individual fields won't offer a
Currency option, either in the query or in the form. The data is displayed in
text boxes.

Any help would be greatly appreciated

TIA
Owen

 

[Ken Snell \(MVP\)]

Just wrap the expression with the CCur function:

FinalFCNCost:
CCur(Nz(POPercentagestoFCNQuery!POtoFCN,0)+Nz(FCNCostQuery![Sum Of
TOTALEQUIPCOST],0)+Nz(FCNCostQuery![Sum Of TOTALLABORCOST],0))