DSum in Access

[bradhanson]

What do I do if wanting to sum my data in a table if it is text in the field that groups them together. In the examples, the grouping is by porductID, but my grouping is by a text field.

DSum("[Amount Aus]","Costs","[Costs.Area]=" & [Costs.Area] And "[Costs.Project Code]=" & [Costs.Project Code]")

The Costs.Project Code is the text field. The Costs.Area part works fine

Any help would be great