Prev: Need to be able to see the PROPERTIES of a query
Next: Right-Align Field When Exporting to Text
From: John on 22 Jan 2010 15:19
Hi All,

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

Thank you
John
From: ghetto_banjo on 22 Jan 2010 15:46
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.
From: orange via AccessMonster.com on 22 Jan 2010 15:50
John wrote:
>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"?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201001/1

From: Jerry Whittle on 22 Jan 2010 16:10
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.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"John" wrote:

> Hi All,
>
> How do you update different values in different cells with differnt values?.
> Thank you in advance.
>
> Thank you
> John
From: Marshall Barton on 22 Jan 2010 18:03
John wrote:
>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.

--
Marsh
MVP [MS Access]
 |  Next  |  Last
Pages: 1 2
Prev: Need to be able to see the PROPERTIES of a query
Next: Right-Align Field When Exporting to Text