Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gdzilla

    avg.

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

    avg.

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

    avg.

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

    avg.

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

    avg.

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

    avg.

    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%?
  7. gdzilla

    avg.

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

    avg.

    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%...
  9. gdzilla

    adding values to a report

    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!
  10. gdzilla

    data pass thru

    It Works! Thanks Stickarm.
  11. gdzilla

    data pass thru

    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)
  12. gdzilla

    data pass thru

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

    search

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

    Calculation

    Thanks for all your help lameid!
  15. gdzilla

    Primary Key

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

    Calculation

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

    Calculation

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

    Calculation

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

Part and Inventory Search

Back
Top