% of total needed

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!
--
c.t.

On Mon, 12 Jan 2009 15:15:01 -0800, christine t.
wrote:

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!

SELECT [Company Name], [Category Type], [Paid Amount], [Paid Amount] /
DSum("[Paid Amount]", "[tablename]", "optional criteria") AS [% of Total
Paid Amount] FROM tablename;

--

John W. Vinson [MVP]

christine t. wrote:

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 ?


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

--
Marsh
MVP [MS Access]