Percent showing hundreds instead of actual percent number

J

JudyT

I have an expression and it returns a percent in a report but in that report
it shows it as 200.0%. This only happens when my date range parameter is
more than over a year period. It works fine for a few months date range but
when I ask for Date range of 8/15/2005 end date 4/15/2006 that is when it
returns 200.0%.
In the report, I have that field set to format to % with 1 decimal place.
Here is the expression.

Expr1: [Reason code totals by date range-Retention and NAVSEA]![SumOfPoint
Value missed]/[Summary exam pts all avail for Retention and
NAVSEA]![SumOfPoints allotted]

Does anyon know how to solve this issue?

Thanks for your help in advance.
 
D

Duane Hookom

I'm not sure how you expect anyone to help you when we don't know anything
about your data. It seems that you are having a problem in your report yet
you are showing us a calculation in a query.

When I have an issue with a calculation that I want to troubleshoot, I
generally open the datasheet view of the report's record source and copy all
the records to the Clipboard. I then paste them into Excel so I can "play"
with the data to find my error.
 
Top