DSum not working in report

[jlg5454]

This formula in my report returns no value.

DSum("[CountOfOpId]","qry_Apps","[Team Name]"='Sales Team 2').

Thanks for any assistance

 

[genomon]

Try replacing "[Team Name]"='Sales Team 2'
with "[Team Name] = " & 'Sales Team 2'

Outside of a dog, a book is man's best friend. Inside of a dog it's too dark to read.

 

[jlg5454]

Thanks,

I tried using your suggestion and I received #error.

 

[genomon]

OOPS! my bad!
Assuming Sales Team 2 is a text box name from the report,
change it to SalesTeam2
THEN
Try replacing "[Team Name]"='Sales Team 2'
with "[Team Name] = '" & SalesTeam2 & "'"

Sorry!!

Outside of a dog, a book is man's best friend. Inside of a dog it's too dark to read.

 

[jlg5454]

Thanks for your help. I figured it out. It should be

=DSum("[CountOfOpId]","qry_apps","[Team Name]='Sales Team 2'")