If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Dividing
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 |
#2
|
|||
|
|||
Dividing
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 "Blade370" wrote in message ... 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 |
#3
|
|||
|
|||
Dividing
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" wrote: 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 "Blade370" wrote in message ... 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 |
#4
|
|||
|
|||
Dividing
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 "Blade370" wrote in message ... 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" wrote: 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 "Blade370" wrote in message ... 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 |
#5
|
|||
|
|||
Dividing
Why not just do the division in the control source of the text box, and set
the format property to percent? "Blade370" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|