Forum Discussion
If Statement returning Exceeds Resources Error
Let's start with the business rule behind this requirement.
" I am hoping to use some sort of randomization so that the retail prices don't simply show the same number marked up for every single product."
I'm not a retail expert, but it does seem unusual to me that a business would randomly and arbitrarily change prices for a number of different products. What is that business rule? Why do price changes need to be random? The very notion seems, well, arbitrary, to me, but without more insight, it's better to hold off on further discussion.
I think you would want to do this with a recordset in VBA, though, if it really does need to be such an arbitrary change. You'd want a table of price ranges and price change percentages, I think, rather than just a random percentage.