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!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Simple Question 1
- Thread starter nayfeh
- Start date
iif(Int([QtyOrdered]>0,[QtyOrdered],""
You're dividing by the same number you're multiplying by, which won't do much.
Also, please read the thread I reference in my sig file. It would be helpful if you made your subject line more informative.
Jeremy ==
Jeremy Wallace
AlphaBet City Dataworks
Affordable Development, Professionally Done
Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
You're dividing by the same number you're multiplying by, which won't do much.
Also, please read the thread I reference in my sig file. It would be helpful if you made your subject line more informative.
Jeremy ==
Jeremy Wallace
AlphaBet City Dataworks
Affordable Development, Professionally Done
Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
-
1
- #3
Unless you're trying to round the number to the nearest multiple of 108...
to not print if it's zero, try this:
iif (Int([QtyOrdered]/108)*108 = 0, "", Int([QtyOrdered]/108)*108)
By the way, if you're basing your report on a query, it might be easier to include the calculation in the query, e.g.
BatchCount:Int([QtyOrdered]/108)*108
iif ([BatchCount] = 0, "", [BatchCount])
to not print if it's zero, try this:
iif (Int([QtyOrdered]/108)*108 = 0, "", Int([QtyOrdered]/108)*108)
By the way, if you're basing your report on a query, it might be easier to include the calculation in the query, e.g.
BatchCount:Int([QtyOrdered]/108)*108
iif ([BatchCount] = 0, "", [BatchCount])
- Thread starter
- #4
Well, I have to agree with Jeremy that a meaningful subject line is useful.
Also, people are not doing this for fame or money, it's an altruistic endeavor (albeit there is *some* free advertising), therefore I don't regard backhanded criticism as correct behavior.
Also, people are not doing this for fame or money, it's an altruistic endeavor (albeit there is *some* free advertising), therefore I don't regard backhanded criticism as correct behavior.
- Thread starter
- #6
Again, thanks for your advice. Very much appreciated and I will try to provide more helpful subject lines in the future. And also direct my question to the right forum. You guys have been very helpful, it is frustrating at times when I can't find the answer since my own knowledge is very limited in programming....all the "tek-ies" have been great and very helpful. And I look forward to helping others in the future with the knowledge I've gained from all of you. I wish I could do it today
Thanks,
TN
Thanks,
TN
- Status
Similar threads
