Calculate Invoice Amt based on Form Response

[Guest]

I have created a report where it gives the balance of the planned budget per
fiscal year. The report genereates a form when open that asks the user to
enter a fiscal year ex: 0506 and based on that response outputs the total
budget.

I know would like to add a text field that will give me a total of all
invoices entered in that fiscal year. And based on what the user enters give
me a total of all invoices during that period. The date format in my
invoice table is a medium date and an example of a fiscal year would be 01
Apr 05 - 31 Mar 06 etc..

I have started to create a dsum expression:
=Nz(DSum("[InvoiceAmt]","tbl_Invoices","[InvoiceDate] "),"$0.00 ")

but I don't know what to specify for Invoice Date because I don't know what
the user will choose?

How do I go about doing this? Any help would be appreciated...

 

[Duane Hookom]

Read the response to your later thread and see if that helps you.

Also, for future reference you should use
=Val(Nz(DSum("[InvoiceAmt]","tbl_Invoices","[InvoiceDate] "),0))
Apply any desired formatting in the format property.