Search results for query: *

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...

grnzbra.. thanks for your all your help, but i'm still getting a one as the output.

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.

hey grnzbra.. i'm sorry, but i don't understand what you said. please explain. thanks!

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!

It Works! Thanks Stickarm.

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...

What's the easiest way grab records from a db for a specific month for a report? thanks!

Thanks for all your help lameid!

How do you reset the auto number-primary key' back to 0 in the database?

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: _________...