Calculating percentage in a field

[CarlaInJax]

I have a report that shows results of a customer service survey. One field
is [Survey sent], one field is [survey returned]. The [survey sent]
indicates the date that the survey was mailed and the field [survey returned]
has a number that indicates the level of satisfaction (i.e., 1=very
satisfied; 2=satisfied, etc.). I'm trying to determine the percentages of
each level of satisfaction. I've done a control of (count([survey returned]
iif 1)/(count [survey returned])). It keeps returning an error. What am I
doing wrong?

 

[Allen Browne]

1. Create a query using this table.

2. Depress the Total button on the toolbar.
Access adds a Total row to the grid.

3. Drag the [survey returned] field into the query design grid.
Accept Group By in the Total row.
If you want to NOT count the ones that haven't returned yet, in the Criteria
row, enter:
Is Not Null

4. Drag the [survey sent] field into the grid.
In the Total row under this field, choose Count.

5. In a fresh column in the Field row, enter an expression to get the count
of surveys returned. Something like this:
DCount("[survey returned]", "Table1")
In the total row under this field, choose:
Expression

You now have the data you need to calculate the percentages.

 

[CarlaInJax]

That works great, but how do I get that infi into my report? My report
currently lists all customers that the survey was sent to and the results of
each. My footer totals the surveys sent and it totals the surveys retured.
I'd like to be able to display the percentages in the footer. If that's not
possible, how would I go about putting the percentages somewhere in the
report?

Thanks.

1. Create a query using this table.

2. Depress the Total button on the toolbar.
Access adds a Total row to the grid.

3. Drag the [survey returned] field into the query design grid.
Accept Group By in the Total row.
If you want to NOT count the ones that haven't returned yet, in the Criteria
row, enter:
Is Not Null

4. Drag the [survey sent] field into the grid.
In the Total row under this field, choose Count.

5. In a fresh column in the Field row, enter an expression to get the count
of surveys returned. Something like this:
DCount("[survey returned]", "Table1")
In the total row under this field, choose:
Expression

You now have the data you need to calculate the percentages.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have a report that shows results of a customer service survey. One field
is [Survey sent], one field is [survey returned]. The [survey sent]
indicates the date that the survey was mailed and the field [survey
returned]
has a number that indicates the level of satisfaction (i.e., 1=very
satisfied; 2=satisfied, etc.). I'm trying to determine the percentages of
each level of satisfaction. I've done a control of (count([survey
returned]
iif 1)/(count [survey returned])). It keeps returning an error. What am
I
doing wrong?

 

[Allen Browne]

Perhaps you could place a subreport in the Report Footer section.
The subreport would use query you just created as its source.

(Or there might be more efficient ways to get the totals into the report
footer, and calculate the totals there.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

That works great, but how do I get that infi into my report? My report
currently lists all customers that the survey was sent to and the results
of
each. My footer totals the surveys sent and it totals the surveys
retured.
I'd like to be able to display the percentages in the footer. If that's
not
possible, how would I go about putting the percentages somewhere in the
report?

Thanks.

1. Create a query using this table.

2. Depress the Total button on the toolbar.
Access adds a Total row to the grid.

3. Drag the [survey returned] field into the query design grid.
Accept Group By in the Total row.
If you want to NOT count the ones that haven't returned yet, in the
Criteria
row, enter:
Is Not Null

4. Drag the [survey sent] field into the grid.
In the Total row under this field, choose Count.

5. In a fresh column in the Field row, enter an expression to get the
count
of surveys returned. Something like this:
DCount("[survey returned]", "Table1")
In the total row under this field, choose:
Expression

You now have the data you need to calculate the percentages.

I have a report that shows results of a customer service survey. One
field
is [Survey sent], one field is [survey returned]. The [survey sent]
indicates the date that the survey was mailed and the field [survey
returned]
has a number that indicates the level of satisfaction (i.e., 1=very
satisfied; 2=satisfied, etc.). I'm trying to determine the percentages
of
each level of satisfaction. I've done a control of (count([survey
returned]
iif 1)/(count [survey returned])). It keeps returning an error. What
am
I
doing wrong?

 

[CarlaInJax]

I was able to get the totals in the footer of the report using text boxes to
do the following =Count (*) to count the total number of surveys sent, =count
([survey returned]) to count the number returned. I used =count ([survey
returned])/count (*)) to get the total percentage of surveys returned, but I
cannot get it to calculate the number of surveys returned by response (i.e,
1, 2, 3, etc) as a percentage of the total surveys returned.

Perhaps you could place a subreport in the Report Footer section.
The subreport would use query you just created as its source.

(Or there might be more efficient ways to get the totals into the report
footer, and calculate the totals there.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

That works great, but how do I get that infi into my report? My report
currently lists all customers that the survey was sent to and the results
of
each. My footer totals the surveys sent and it totals the surveys
retured.
I'd like to be able to display the percentages in the footer. If that's
not
possible, how would I go about putting the percentages somewhere in the
report?

Thanks.

1. Create a query using this table.

2. Depress the Total button on the toolbar.
Access adds a Total row to the grid.

3. Drag the [survey returned] field into the query design grid.
Accept Group By in the Total row.
If you want to NOT count the ones that haven't returned yet, in the
Criteria
row, enter:
Is Not Null

4. Drag the [survey sent] field into the grid.
In the Total row under this field, choose Count.

5. In a fresh column in the Field row, enter an expression to get the
count
of surveys returned. Something like this:
DCount("[survey returned]", "Table1")
In the total row under this field, choose:
Expression

You now have the data you need to calculate the percentages.

I have a report that shows results of a customer service survey. One
field
is [Survey sent], one field is [survey returned]. The [survey sent]
indicates the date that the survey was mailed and the field [survey
returned]
has a number that indicates the level of satisfaction (i.e., 1=very
satisfied; 2=satisfied, etc.). I'm trying to determine the percentages
of
each level of satisfaction. I've done a control of (count([survey
returned]
iif 1)/(count [survey returned])). It keeps returning an error. What
am
I
doing wrong?