DSum help

[SnowB1]

In my report I have an unbound textbox with Control Source =DSum("[Homeless]","ReportCountyQuery","[Homeless]='yes'")
homeless is a field in ReportCountyQuery and is a text field with yes/no in it. Can anyone tell me why I am getting #error in my textbox. Thanks.

Bobby

 

[SnowB1]

Thanks Pat, actually I just moved the DSum into my Query and it works great except that I am getting the sum for as many records as there are. If you know how I could fix that I would greatly appreciate it. Thanks.

Bobby

 

[Rich]

Your DSum doesn't belong in the query, take it out. What is your Report based on, is it the same query ?