No worries. All good help here and very much appreciated. I would have never figured out the methods provided here for this subject. The rounding p...
For the most part, this works. At least on the one number I was getting the rounding error. However, for the life of me, I have no idea why power qu...
Looks that way. Is there a way, within the "bonus" calculation formula to add a "round" feature to use the figure of 81.833 to multiply to the 1.5% t...
Quick note here as I finally could test the last part with the "bonus" applied for anything over 300. There appears to be some "rounding" issues as o...
Both appear to work very well. The problem I have is, I am "good" with the understanding once I break this out until the code within the "if" / "then...
Thank you both. Just an initial look, while it does achieve the objective, there are a few steps I am not familiar with so want to review more to try...
This seems to work and I see where you are coming from. It's not the rows I have, it's the rows of the source. I need to take a longer look at your ...
File should be here this time.
Attached is the actual query if you wanted to see the full "version."
Not that large; only 60 total rows.
I know. Hard to get the intention across. And, I just am not that familiar with queries. The main thing with the rows, after row 2, I needed to inse...
I figured this out. The “null” actually works. Initially, I was replacing blank with “null,” not the actual “0” (zero). Putting the “0” instead of ...