Calculate a Percentage based off one record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a subreport that I need to calculate a percentage. The calculation
should look like this: [MaturationCost]/[Customer D/C Expense]*100.

My problem is that I need to select one specific record for the Customer D/C
Expense based on a field name [Modification Category]. The Category should
be the value "GO TOOLING". This value is in the subreport as one of the
records.

I have tried to create a select query to specify the "GO Tooling" but I'm
having trouble tying it all together.

SELECT [tblMaturation Expense].[Part Number], [tblMaturation
Expense].[Modification Category], [tblMaturation Expense].[Customer D/C
Expense]
FROM [tblMaturation Expense]
WHERE ((([tblMaturation Expense].[Modification Category])="TOOLING GO"));
=Sum (Nz[MaturationCost]/[Customer D/C Expense]*100)

I know I'm not doing this correctly, but I'm not sure how else to do this.
All help would be greatly appreciated.

Thanks!!
G. Wolfe
 
Sorry about that it's "Go Tooling"

Chris Reveille said:
Is it "Go Tooling" or "Tooling Go"? You have it both ways.

-----Original Message-----
I have a subreport that I need to calculate a percentage. The calculation
should look like this: [MaturationCost]/[Customer D/C Expense]*100.

My problem is that I need to select one specific record for the Customer D/C
Expense based on a field name [Modification Category]. The Category should
be the value "GO TOOLING". This value is in the subreport as one of the
records.

I have tried to create a select query to specify the "GO Tooling" but I'm
having trouble tying it all together.

SELECT [tblMaturation Expense].[Part Number], [tblMaturation
Expense].[Modification Category], [tblMaturation Expense].[Customer D/C
Expense]
FROM [tblMaturation Expense]
WHERE ((([tblMaturation Expense].[Modification Category])="TOOLING GO"));
=Sum (Nz[MaturationCost]/[Customer D/C Expense]*100)

I know I'm not doing this correctly, but I'm not sure how else to do this.
All help would be greatly appreciated.

Thanks!!
G. Wolfe



.
Click to expand...
Click to expand...
 
Back
Top