percent not dislaying correctly

[Funkbuqet]

I have a report setup up that is pulling data from 2 queries. The first query (SegProgress) calculates the percentage complete of the work segments. Groups of segments belong to STR's, so the second query (STRProgress) is used to calculate the percentage complete of each STR. I have it grouped so the STR and its information is in its heading with the appropriate segments and their info listed below it. Everything is working well except the STR percentage is only showing up as 100% or 0%. When I change the format from percentage to standard it only dislpays 1 or 0. Any value less than 100% is displayed as 0%. The strange thing is that the values are displayed correctly in the query and if I make a report using just the STRProgress query the values show up fine as well, and I can't find any diference in formatting. All of the SegProgress values show up fine in the report. Any help would be appreciated. Thank you.

 

[boblarson]

You must be working with INTEGERS instead of using Single, Double, or Currency. Integer and Long Integers don't have decimals so the percent rounds to either 0 or 1 (100%).

 

[Funkbuqet]

Thats what I was thinking but in the query it is formatted as a double and works fine, while in the report there is no place to choose between integer or double. Under format ihave it selected as a percentage. I think I may just have t add an unbound box into the report and do the calculation in it. Thanks.

 

[boblarson]

Oh, if you have it formatted as a percent in the report, make sure to divide the result by 100.

 

[Funkbuqet]

I never did figure out what the root of this problem was, but I solved it by calculating the STRprogress percent within the report rather than pulling it out of the query. Thanks for the help.