percentage calculated shows in form, but not in report

Hello,
Being new to Access, we are trying to make a field in the Report show a
calculation (defects/rejects).
This was usually calculated by the user, then typed into the database.
We would like to make this an automatic calculation.
After a few days of trying, we have got as far as to have the percentage
show up correctly in the Form (2.2%for the one instance we are working with),
but in the report, that is printed out and emailed, we still get 0% in the
box stating "% Rejected"
we click on the "properties"
Format : Percentage
Data: Control source : =[Defect Qty/Reject Qty]*100

We have gone through many iterations of scenarios and the results varied
from diffferent error types to inaccurate results.
We know that the 2.2% shown in the Form is accurate, but how do we get the
Report to show the same number?
Your help is appreciated
Thanks
Driftwood

I assume you have 2 fields Defect Qty & Reject Qty, in which case your
control source should be as below
=[Defect Qty]/[Reject Qty]*100

"Driftwood" wrote:

Hello,
Being new to Access, we are trying to make a field in the Report show a
calculation (defects/rejects).
This was usually calculated by the user, then typed into the database.
We would like to make this an automatic calculation.
After a few days of trying, we have got as far as to have the percentage
show up correctly in the Form (2.2%for the one instance we are working with),
but in the report, that is printed out and emailed, we still get 0% in the
box stating "% Rejected"
we click on the "properties"
Format : Percentage
Data: Control source : =[Defect Qty/Reject Qty]*100

We have gone through many iterations of scenarios and the results varied
from diffferent error types to inaccurate results.
We know that the 2.2% shown in the Form is accurate, but how do we get the
Report to show the same number?
Your help is appreciated
Thanks
Driftwood

If, as the "% Rejected" label suggests, it’s the reject quantity as a
percentage of the defect quantity that you want, you have the expression the
wrong way round. It would be:

=[Reject Qty]/[DefectQty]

This will give the value as a decimal fraction, e.g. 0.022

Formatting this as Percent will display this as 2.2%, so you don't need to
multiply by 100.

Ken Sheridan
Stafford, England

Driftwood wrote:
Hello,
Being new to Access, we are trying to make a field in the Report show a
calculation (defects/rejects).
This was usually calculated by the user, then typed into the database.
We would like to make this an automatic calculation.
After a few days of trying, we have got as far as to have the percentage
show up correctly in the Form (2.2%for the one instance we are working with),
but in the report, that is printed out and emailed, we still get 0% in the
box stating "% Rejected"
we click on the "properties"
Format : Percentage
Data: Control source : =[Defect Qty/Reject Qty]*100

We have gone through many iterations of scenarios and the results varied
from diffferent error types to inaccurate results.
We know that the 2.2% shown in the Form is accurate, but how do we get the
Report to show the same number?
Your help is appreciated
Thanks
Driftwood

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/200910/1