Recent content by JNelson0318

Pat, I think I may have it - getting expression too long on some queries but I'm working on that....I appreciate your help. Also, getting #Num! output for Cost per Load. Would that be the same concept as the Div0 error? Jann

Pat, Can you explain this in more Detail? Do I bring up the report and go to the Source for the Units, Rate, and Hours fields and enter this formula in each of those Fields? Select fld1, fld2, fld3, IIf(NZ([Units],0) = 0, [Rate]*[Hours], [Rate]*[Hours]/([Units]) As TotCost, fld4, .... From...

Pat, Ok finally, I tried this by just copying my Dividend and Divisor used in original Formula: = (IIf(Nz(Sum([Units]),0) = 0, =Sum([Rate]*[Hours]), =Sum([Rate]*[Hours])/Sum([Units])) Now I get the following error: The expression you entered contains invalid syntax. You may have...

Pat, I added this to my Field: = (IIf(NZ([Units],0) = 0, [Rate]*[Hours], [Rate]*[Hours]/([Units]) It is giving me the following error: "The expression you entered is missing a closing parenthesis, bracket(]), or vertical bar(|)"

New to Access...where would I enter this code?

Pat, I'm new to MS Access...where do I enter this code?

If one of the fields are 0 then it returns this error on my Reports in the Field and/or in the Sum of these. I read somwhere to create a tblDivByZero table but since I'm a novice I still can't make this work. Hopefully, someone can assist me with this.

My name is Jann and I have been only using Access for a little over a year. I love the process and enjoy learning new things to try and enjoy the forum to find answers to my questions. I live in the United States in southern Florida and hopefully, will continue to learn.:)