Solved Work out Percentage using input from a form as part of the sum (1 Viewer)

[murray83]

I'm trying to work out the percentage of failures for a days intake, so the days intake will change hence why i would like it taken from a form
but I do have the meat of the problem as can see here, just not sure how to plug in the form bit, which in the example below is the number 37.

I guess it would be something like

forms!formname!etc[/code0

so any help be great cheers o and one last thing, how do i keep it to say 2 decimal points as at the moment looks like this

current coding
[code] Percentage Failed: [CountOftxtMeasureCodeTrim]/37*100

 

[Ranman256]

in the query or textbox property, set format =percent
and decimals = 2

 

[murray83]

cheers for that

and i managed to fix it by just making it a part of the query, so no need for a text box for people to type in

 

[jdraw]

You could also try
Round([CountOftxtMeasureCodeTrim]/37*100,2)