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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculated Control - Sum one field based on value in another fiel 1
calculated value 11
Select records based upon calculated totals 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Multiple calculation problem 5
Overwriting a cell with a formula without deleting the formula 1
Excel base year add up escalation problem.... 1
set record source of subreport 4

Back
Top