Search results

Thanks Guys for your help I know can get a DSum to total area; DSum("[Amount Aus]","Costs","[Costs].[Area]=" & [Costs].[Area]) As well as the Project; DSum("[Amount Aus]","Costs","[Project Code]='" & [Project Code] & "'") So I thought putting a combination of the 2 with a AND in there would...

I must be thick, because I still can't get it working. What I am ultimately trying to achieve is the adding up of my [Amount Aus] fields in a [Costs] table in groups according to [Area] AND [Project Code]. [Area] is numeric and [Project Code] is text Project 1, Area 1 total is $1000 Project...

Tried but can't get my head around the ' and the " and the &. What needs to be where. I tried as per below but still no good DSum("[Amount Aus]","Costs","[Project Code]=' " & [Project Code] & " ' ")

Thanks, I'll give it a try

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 productID, but my grouping is by a text field. DSum("[Amount Aus]","Costs","[Costs.Area]=" & [Costs.Area] And "[Costs.Project Code]=" & [Costs.Project...