Hello all.. This seems like a very simple problem, but I can't seem to figure it out. I'm sure this will be an easy one for you experts!
I have a table which shows me the price of a list of items. What I need is to be able to change the price of the items by simply entering in a percentage into an expression which will then change all of the prices in that table by that percent.
Example:
Product Table:
PRODUCT.....PRICE
Hats.......... $20.00
Scarfs.........$10.00
Shoes...........$50.00
So now if I want to find out how much the price would be for all of those items at 90%, I want to be able to type in "90%" into my text box which would produce a table like this:
PRODUCT.....PRICE
Hats.......... $18.00
Scarfs..........$9.00
Shoes..........$45.00
For the field [PRICE] I would have an expression that would be: [PRICE]*[TEXTBOX] where the text box is whatever value the percent would be...
I tried just using a parameter which works for updating the price by percent. But I need to use the results of the table for other queries which then will be used in a report to calculate some other information. When I run my report which is based off of queries that is based off this table, I get a pop-up window that says "The Microsoft Access database engine does not recognize '[ENTER PERCENT]' as a valid field name or expression."
Meaning that it won't let me use the parameter box.
Does anyone have any suggestions?