- Joined
- Jul 17, 2007
- Messages
- 3
- Reaction score
- 0
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
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