Dividing

[Guest]

I have a query which is summing one field and counting another. In the 3rd
column I have an expression which takes the sum divide by the count
multiplied by 100 to give an overall percentage. It seems to work fin until i
add a fraction in like 0.5 to the summed field then the percentage doesn't
seem to change to reflect this.

Example 1.5/3*100 = 50% on my query it is still showing as 100% and no
matter what else you add to the summed field it remains like that.

Any Ideas???

Thanks

 

[Jeff Boyce]

When you "add a fraction in like 0.5", are you trying to add 0.5%, or the
decimal fraction 0.5 (which equals 50%)?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

I am just trying to add 0.5 as in the fraction. Not 0.5 %.

just like in arithmetic (1+0.5)

Regards

 

[Jeff Boyce]

We're not there, we can't see the query, nor the "summed field" you
mentioned.

Where are you trying to "add in" the value. The expression you gave didn't
have any addition showing in it.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Why not just do the division in the control source of the text box, and set
the format property to percent?