All, I am trying to sum the values in a query based on drop-down selections from a form. The summation will be displayed in the form. As the control source of the list box where I want the summation to be displayed, I have the following:

=DSum("[Value]","qryAssets","[Month] = [Forms]![frmOne]![cboMonth] AND [Location] = [Forms]![frmOne]![cboLocation]")

The form is obviously named 'frmOne' and the drop-downs are named 'cboMonth' and 'cboLocation'. Location, Month and Value are all in the qryAssets query, but I am not generating any results. Anyone possibly know why?



Also, if someone wanted to filter only on month and not location, how would I go about adding a wildcard for location in the equation? Thanks for any help.