Expression

[jltm8]

I am using the following expression in access 2007
=DSum("[jqty]","SHIP","[jprod#] = '" & [pn] & "'")



I need to add a date range criteria to this expression that looks at the field [expr1] and sums anything between the two selected dates.

Can anyone help me with this?

[jltm8]

I am using the following expression in access 2007
=DSum("[jqty]","SHIP","[jprod#] = '" & [pn] & "'")

I need to add a date range criteria to this expression that looks at the field [expr1] .

Can anyone help me with this?

[pbaldy]

This has a multi-criteria example at the bottom:

DLookup Usage Samples

[pbaldy]

Please don't post the same question twice:

https://www.accessforums.net/access/...ion-18658.html

[June7]

=DSum("[jqty]","SHIP","[jprod#] = '" & [pn] & "' AND [datefield] Between #" & startdate & "# AND #" & enddate & "#")

How do you want to input the start and end dates - by reference to textboxes on form? Where is the PN criteria from?

BTW, advise not to use spaces, special characters, punctuation (underscore is exception) in names. Better would be jProdNum.

[jltm8]

I have date pickers set up on the from for picking the dates. The PN criteria is pulling from a drop down list on the same form.

Thank you for the advice, I will be trying this out.