Hopefully my subject makes sense.
I have a database written for processing a quote to be sent to customers.
If the text box containing a cash incentive is completed, I need the "Preview Quote" box when clicked to print one particular report (which includes the cash incentive). If there is...
Thank you so much for the help. I tried the statement from GingerR and it worked great.
=IIf(([Price]/0.6)=Int([Price]/0.6),[Price]/0.6,Int((([Price]/0.6)+10)/10)*10)
One more question though -
The formula is used in a report. I found two instances, so far, when the number does not round to...
Is it possible to roundup a number calculated via a formula? Example: My formula currently reads:
=Round([Price]/.6)
Can the answer be rounded up to the nearest 10? In other words, we need an answer of $14.20 to round up to $20.00. $208.00 needs to round up to $210.00.
All...
Thanks for your quick answer. Before I review it, let me explain that I have been programming in Access for about 3 years, but not to any large degree. The program I am currently working on is one that we use at my office to print window stickers for our inventory. I am working to add some...
I have a form designed to basically open another form. The reason for this is simple. From my main menu, when you click the button to edit/delete inventory, a box appears that shows the stock # and model. When you highlight a piece of inventory and click the select button (or when you double...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.