I have a text box on my form that calculates the total of all purchases. I saw a rounding function in Access, but I need something that I can customize. For example, if the total order is $90, it would round it to $100, if the order is $19, 693 it would round it to $20K. Basically, it would round depending on the total. Is there a function like that in Access or do I need to create the code myself?
Thank you.
Thank you.