Format not working

[chefdaveross]

Now I cant seem to get this total to work.

I used to have it working on an earlier version with this:

=FormatCurrency(DSum("[cost]","qryRecipeLB"),2)

but its different now.

any thoughts?

also tried:

=Sum(([txtRecAmt]*[ItemCostTextBox])/[RecItem].[COLUMN](3))

I saw you tried:

=IIf(IsNull([RecItem].[COLUMN](3)),1,Sum((Nz([txtRecAmt],0)*Nz([ItemCostTextBox],0))))