Update query

[John]

Hi All,

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

Thank you
John

 

[ghetto_banjo]

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.

 

[orange via AccessMonster.com]

Hi All,

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

Thank you
John

We're talking Access, right John? What exactly do you mean by "cells"?

 

[Jerry Whittle]

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.

 

[Marshall Barton]

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

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.

 

[John W. Vinson]

Hi All,

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

Thank you
John

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.