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

N

N.N.

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??
 
A

Allen Browne

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