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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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