percent rounding to 100 on report - why?

[fredk]

I have a table that has a field that I want to be a percent - This is keyed in monthly and gives the percentage of goal for each sales rep.

I currently have it as a number (long integer) formatted as a percent.

I run a query that pulls this information along with information from another table.

When the data shows up in the report, it shows as 100% even though all numbers are .83 to .89 - How can I get it to not round to 100% ????

Not sure if this makes a difference but the tables are housed somewhere else and just linked to where I am running the reports -

This is one of those that I just can't figure out even though I know that there must be an easy answer.

Thanks in advance for your help!!!!!

 

[hsitz]

I think the problem is that you're using a long integer type, as in 0, 1, 2, 3, 4. . . Because an integer can't represent a fraction of a number, all of your xx/100 percentages are getting rounded up to 1.

Try changing the field type from Long Integer to Single, which allows you to use decimals. -- Herb

 

[fredk]

Hank - Thanks a million - That did it -