Hi Guys,
Trying to sum fields based on a ID from a form, and a text field, fixed - my version is below - what am I doing wrong?
=DSum([total],[qrybudget],"[ProjectName] = " & [me].[ID] & " And ctrBudgetType = 'Seed'")
ProjectName is a number field, and ctrBudgetType is a text.....
Thanks in advance,
Trying to sum fields based on a ID from a form, and a text field, fixed - my version is below - what am I doing wrong?
=DSum([total],[qrybudget],"[ProjectName] = " & [me].[ID] & " And ctrBudgetType = 'Seed'")
ProjectName is a number field, and ctrBudgetType is a text.....
Thanks in advance,