Format Problem

[Bob]

--
I want to add this format to the Control Source
$#,##0.00;($#,##0.00)
="O.D. Amount: " & NZ(DSum("OwnerPercentAmount","tblInvoice","OwnerID =" &
tbOwnerID.Value & " and InvoiceDate <" &
Format("Forms!frmBillStatement![tbDateFrom]","mm/dd/yyyy")),0)-NZ(DSum("PaidAmount","tblAccountStatus","OwnerID
=" & tbOwnerID.Value & " and BillDate <" &
Format("Forms!frmBillStatement![tbDateFrom]","mm/dd/yyyy")),0)


Thanks for any Help

 

[fredg]

On Wed, 10 Jan 2007 12:40:27 +1300, Bob wrote:

I want to add this format to the Control Source
$#,##0.00;($#,##0.00)
="O.D. Amount: " & NZ(DSum("OwnerPercentAmount","tblInvoice","OwnerID
=" &
tbOwnerID.Value & " and InvoiceDate <" &
Format("Forms!frmBillStatement![tbDateFrom]","mm/dd/yyyy")),0)-NZ(DSum("PaidAmount","tblAccountStatus","OwnerID
=" & tbOwnerID.Value & " and BillDate <" &
Format("Forms!frmBillStatement![tbDateFrom]","mm/dd/yyyy")),0)


Thanks for any Help

="Something here " & format([SomeField],"$#,##0.00;($#,##0.00)") & "
some more stuff."