Replacing only certain records in a query

G

Guest

I have a table that has three fields [types of fruit], [total number of
fruit], and [price]. What I want to do is take only one type of fruit
“apples†and change their total numbers and prices using a query. How would
I go about doing this?
 

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

Single Query for Top 10 of Multiple Items 1
append table query 2
Oranges, Apples and Bananas...Selective Query! 9
Return Totals for multiple categories from a subreport 4
Find and replace 5
Monthly Data Analysis 2
Show true "repeated" entries 6
Referencing text from another cell for criteria in functions 1

Top