Update query

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi All,

How do you update different values in different cells with differnt values?.
Thank you in advance.

Thank you
John
 
short answer: create an update query


detailed answer: you are going to need to provide some more detail on
exactly what you are looking to do for people here to help.
 
We will need to see a sample of the data and what you want to do with it to
even hazzard a guess.

Also databases don't have cells. They have records and fields/columns. Excel
spreadsheets have cells. If this is an Excel question, you may want to ask
elsewhere.
 
John said:
How do you update different values in different cells with differnt values?.
Click to expand...


This one has got to be a contender for the foggy query
question of the year, and it's only January ;-)

Seriously, you can update different FIELDS by using multiple
assignments separated by comma:

UPDATE table
SET fieldA = this, fieldB = that, fieldC = theother
WHERE something

The values can be different only if they set to an
expression that refers to other fields in the record.
 
Hi All,

How do you update different values in different cells with differnt values?.
Thank you in advance.

Thank you
John
Click to expand...

By running an appropriate update query.

Your question is impossibly vague. Please try again, bearing in mind that
nobody here can see your screen or read your mind.

Also note that Access is not Excel; Excel has "cells", Access doesn't.
 
Back
Top