I think I have cracked the % problem I was having. My new problem is that the resulting answer gives the answer to about 15 decimal places. I only want it to 1!

I have tried going into properties and changing the number format to Gen Number and % with no decimal places or even 1 - but it still keeps giving the answer to about 15 decimal places. What can I do? Is there any syntax that I need to add to the expression. The expression I use is:

=100/[Total Pers]*[Total]&"%")

It gives me a dead on answer but to too many decimal places. Help would be most grateful.

My Email address is Lorddy545@aol.com

Try using a format of Fixed and then specify 1 as number of decimal places. I have had this same problem, and that has always worked. I've used it in the table design mode and the query design mode as well.