Recent content by b3026

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...