Good morning
I am creating a report which lists outstanding jobs and their cost. The Cost value is dependent on a "CostPer" field which has a value of "Job", "Each" or "1000".
So the calc will be
How do I calculate the TotalCost field in the report? Query? VBA?
<<Feeling particularly dumb >>
TIA
I am creating a report which lists outstanding jobs and their cost. The Cost value is dependent on a "CostPer" field which has a value of "Job", "Each" or "1000".
So the calc will be
Code:
If CostPer = Job Then
TotalCost = Cost1 + Cost2
ElseIf CostPer = Each Then
TotalCost = (Cost1 * Quantity) + Cost2
ElseIf CostPer = "1000" Then
TotalCost = ((Cost1 * Quantity) / 1000) + Cost2
End If
How do I calculate the TotalCost field in the report? Query? VBA?
<<Feeling particularly dumb >>
TIA