Syntax

[mlyles]

I am trying to get the sum of the government workyears with the appropriation id with any letters with GE on the current form that is showing. Here is what I have so far but everytime I try to add something it gives me #Name? :
=DSum(" [Government Workyears] ","tbl-costs","[Task ID] = [Forms]![frm-Tasks-Summary]![Task ID] And [Appropriation ID] Like "*GE*" ")

 

[KenHigg]

Did we just do this?

kh

 

[mlyles]

I don't believe there is an extra " .

 

[KenHigg]

okie dokie then...

What about:

=DSum(" [Government Workyears] ","tbl-costs","[Task ID] = [Forms]![frm-Tasks-Summary]![Task ID] And [Appropriation ID] Like '*GE*'")