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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Group last line of details and report footer 0
Sum of numbers 21
Excel Formula 1
Adding Criteria to Access Reports 2
How can I change all values in a spreadsheet by a certain percent 3
Conditional Formating with Icon set - How to change the color 3
Global Change Of Formula Value 2
Use combo to print report between two sets of dates 1

Top