Search results
-
O
Update query - calcualte a percentage input by user?
One more question, sorry, forgot to ask earlier... In the prompt I wanted to say something like "Please enter a percentage, E.G. 10% or -10%" so the user would realize they could just enter a negative number to decrease the price, but Access wont allow me to use a % sign in the message to the... -
O
Update query - calcualte a percentage input by user?
Thanks for the quick responses! Thanks especially to Brian, your suggestion worked great :) I removed the quotes and entered: [Price]+[Price]*[Enter a Percentage:]/100 Thanks again ;) -
O
Update query - calcualte a percentage input by user?
Hi, I'm new to MS Access and have a question about Parameter queries. I have a "Parts" database that contains part numbers, descriptions, and prices and I'm trying to create an Update Query that will prompt the user for a part number, then prompt them for a percentage to increase or decrease a...