dsum inquiry

T

Tina

=Nz(DSum("[Allocation_Amt]","qry_allocation_partner_equip","[Partner_ID] = "
& [Partner_ID] And "[InvoiceDate] Between #4/1/06# and #31/3/07#"),"$0.00 ")

I have the following statement in a text field of my report. It gives me
the sum of all partners. I only want the amount if the partner id matches
and the invoice is between specific dates.

Does it look like I've done some thing wrong?
 
D

Duane Hookom

Place the "AND" inside the quotes. As per a previous post, your expression
should be consistant with its return value. Choose either text or numeric.
For instance:

=Val(
Nz(DSum("[Allocation_Amt]","qry_allocation_partner_equip","[Partner_ID] = "
& [Partner_ID] & " And [InvoiceDate] Between #4/1/06# and #31/3/07#"), 0) )
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DSUM 7
#Error 5
DSum with Criteria 8
Calculate Invoice Amt based on Form Response 1
Dsum in report header problem 6
Has No Data 1
Excel To Access 1
report based on select query 1

Top