Report with percentages of total

  • Thread starter Thread starter xp
  • Start date Start date
X

xp

I'm trying to write a report which will yield something like the following:

John 1 25%
Mary 2 50%
George 1 25%
Total 4

I am having trouble getting the percentages. I put a text box in the report
DETAIL area and entered the formula:

=DCount("USER_NM", "tblStats")/DCount("*","tblStats")

But this fails...any ideas?

Thanks!
 
xp said:
I'm trying to write a report which will yield something like the following:

John 1 25%
Mary 2 50%
George 1 25%
Total 4

I am having trouble getting the percentages. I put a text box in the report
DETAIL area and entered the formula:

=DCount("USER_NM", "tblStats")/DCount("*","tblStats")
Click to expand...


We need to know what the report's input looks like before
explaining how to get that output. Please provide a small
sample of the data records the report is processing.
 
A WAG is a control source like:
=USER_NM/Sum(USER_NM)
This assumes you want the percent of the USER_NUM compared to the total
USER_NM displayed in the report.

DCount() is generally a poor function to use in this situation.
 
Back
Top