Changing Values

  • Thread starter Thread starter steenman2
  • Start date Start date
S

steenman2

I am having a problem with a report I am trying to create.

It is based off of a query and has about 7 columns of data/information
values. There is a persons name and then their department and then some
percentages about that person. All of these columns of values are ok
except for one whch displays a completly different percent than what
what you get when you run the query by itself.

The report is based only on that one query so I know I am not selecting
the wrong field.

Does anyone have any idea why this is happening.


Thanks
 
What's the name of the field? What do you mean by "completely different"?
Can you provide some samples? Is the text box wide enough to display the
value? Have you checked the Format and other display properties?
 
The box is plenty wide, and all of the formatting is correct. An
example below.



Name Right Value Display value
Bob 113.50% 110%
Matt 106.5% 100%
Bob 125.30% 120%
Matt 124.30% 120%

The persons name is on the right. In the Right Value column is the
correct value I get when I run the just the quesry in preview mode. The
Display Value column are the results I am getting in the report.

Keep in mind there are 9 other similar percentage columns but they are
all displaying correctly.


Thank you for your reply
 
You ignored a couple questions:
What's the name of the field? Have you checked the Format and other display
properties?

All values look like they are being rounded down to the nearest 10%. Is this
consistently true?
 
Sorry,

The nam of the field in question is "Q2 Pref" with out the quotes
ofcourse. As far as the formating and display, I have double and
tripple checked them. And yes they are all rounding down consistently

Thanks again
 
I would try copy a working text box and replace the control source with
Control Source: [Q2 Pref]
This would copy all the format and other properties of a working text box
but use the other field name.
 
Back
Top