Calculate a Percentage based off one record

G

G. Wolfe

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
 
G

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...
 
Top