% of total needed

  • Thread starter Thread starter christine t.
  • Start date Start date
C

christine t.

I need to add a field showing the % of total. The table looks like this:

Company Name Category Type Paid Amount % of Total Paid Amount

Armstrong Copy Paper $50.00 ?
Jonas Envelopes $50.00 ?

Thanks!
 
I need to add a field showing the % of total. The table looks like this:

Company Name Category Type Paid Amount % of Total Paid Amount

Armstrong Copy Paper $50.00 ?
Jonas Envelopes $50.00 ?

Thanks!
Click to expand...

SELECT [Company Name], [Category Type], [Paid Amount], [Paid Amount] /
DSum("[Paid Amount]", "[tablename]", "<optional criteria>") AS [% of Total
Paid Amount] FROM tablename;
 
christine said:
I need to add a field showing the % of total. The table looks like this:

Company Name Category Type Paid Amount % of Total Paid Amount

Armstrong Copy Paper $50.00 ?
Jonas Envelopes $50.00 ?
Click to expand...


You should not put calculated values in a table. That kind
of thing should be calculated when the records are displayed
in a form or report.

Use an text box (named txtTotal) with an expression like:
= Sum([Paid Amount[)
in the form/report header section, or in a report's group
header section. Then the percent text box would use an
expression like:
= [Paid Amount] / txtTotal
 
Back
Top