Where do I enter a formula to change the value of selected cells .

I have imported a lengthy Excel Spreadsheet into Access (also tried linking).
The spreadsheet contains 3 columns: Description, CODE, and PRICE. I put
criteria in the query for CODE to pull out only those code numbers I need for
the report. I need to also, for those code numbers, have the PRICE show
with changed values based on percent increase/decrease. Can this be done?
If so, where do I put a formula or criteria to change the prices for the
report??

To perform bulk updates on the price, use an Update query on this table:
Update on Query menu in query design view.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"N.N." wrote in message
...
I have imported a lengthy Excel Spreadsheet into Access (also tried
linking).
The spreadsheet contains 3 columns: Description, CODE, and PRICE. I put
criteria in the query for CODE to pull out only those code numbers I need
for
the report. I need to also, for those code numbers, have the PRICE show
with changed values based on percent increase/decrease. Can this be
done?
If so, where do I put a formula or criteria to change the prices for the
report??