grnzebra...
i just figured out why i am getting a one instead of a zero. i was grabbing the wrong value. i needed to use the value from "One" instead of "Two". sorry for putting you through that. this formula works...
yes, that is what's happening. the sum of TwoReq is zero, but it's outputing a '1' instead of grabbing the zero.
i'm not sure where it's even getting the '1' since when the calculation is done the answer should still be zero.
yes, that is what's happening. the sum of TwoReq is zero, but it's outputing a '1' instead of grabbing the zero.
i'm not sure where it's even getting the '1' since when the calculation is done the answer should still be zero.
it has a zero.
i changed the parameter for the denominator to the correct one:
=IIf(Sum([qryStatistics]![TwoReq])=0,0,Sum([qryStatistics]![TwoReqNot])/Sum([qryStatistics]![TwoReq]))
it's no longer giving me errors, but it's output is 100% when it should be a 0%?
hey grnzbr...
thanks for the response. i change my expression to the following from what you said:
=IIf([qryStatistics]![OneReq]=0,0,Sum([qryStatistics]![TwoReqNot])/Sum([qryStatistics]![TwoReq]))
when i tried to run it in my report it asks for the value of "qryStatistics" when it...
i have an expression that calculates the average of two pieces of data: =Sum([qryStatistics]![IspReqNot])/Sum([qryStatistics]![IspReq])
the problem is the values that are being divided is "0": 0/0
so the percentage is 0 which is returning an error.
how can make it output a 0%...
hello.
what is the expression that i would write that would add up the value from all the rows of a field in a query for a report?
example:
FIELD
1
0
1
1
1
so, what is the expression that i would enter in a text box in a report to get the sum of "4"?
thanks!
Stickarm... Do I first need to create a macro for this?
I'm getting this error "Microsoft Access can't find the macro 'WorkerID=WorkerName.'
This is what I entered in the AfterUpdate event:
WorkerID= WorkerName.Column(1)
In a Form.....
How can I do it so that when someone chooses an option from a "combo box", a value associated with it automatically comes up in the next field.
For example:
Field1(Combo Box,2 columns) Field2
option1-data1
option2-data2
option3-data3
so let's say someone chooses...
Complaint: IIF([Field] = "Complaint",1,0)
okay, i got that working for one field, but i have how do i add up more than one field of 'compliant's'like how it is in my form?
For this example it should output "2".
***DETAIL***
N/A 1.Question?
Compliant...
I kind of understand what your saying, but don't really know how to implement it and as you can tell I'm very new to access.
How would I enter the calculation in a query? under the "total" input area?
if you put it in plain english for me it would be great!
Thanks again.
I created a form that looks something like this:
***DETAIL***
N/A 1.Question?
Compliant 2.Question?
Not Compliant 3.Question?
Compliant 4.Question?
Not Compliant 5.Question?
and so on.....
************
***FOOTER****
Total N/A: _______
Total Complaint: _________
Total Not Compliant: _________...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.