<div>
try this update statement example<br />
<br />
update table_name<br />
set field1 = field1_value, <br />
field2 = field2_value<br />
where id = 1<br />
<br />
<br />
hongjun
</div>


try this update statement example

update table_name
set field1 = field1_value,
field2 = field2_value
where id = 1


hongjun

<div>
Syntax<br />
UPDATE [DatabaseName1!]TableName1<wbr /><br />
SET Column_Name1 = eExpression1<br />
&nbsp; [, Column_Name2 = eExpression2 ...]<br />
&nbsp; WHERE FilterCondition1 [AND | OR FilterCondition2 ...]]<br />
<br />
<br />
Good Luck.
</div>


Syntax
UPDATE [DatabaseName1!]TableName1
SET Column_Name1 = eExpression1
  [, Column_Name2 = eExpression2 ...]
  WHERE FilterCondition1 [AND | OR FilterCondition2 ...]]


Good Luck.

<div>
I think you have forgotton to post your code, anyways hongjun and yongyih are correct for the update statement. How were you doing the same then??<br />
<br />
-priya
</div>


I think you have forgotton to post your code, anyways hongjun and yongyih are correct for the update statement. How were you doing the same then??

-priya

<div>
I tried the above and it gives me a parameter error. &nbsp;Here is my code.<br />
<br />
sSql1 = &quot;UPDATE 22shop_5min SET jobnumber= &quot;&nbsp;&amp; JobNumber22 &amp;&nbsp;&quot; where [22shop_5min].id = 1&quot;<br />
<br />
If I had fields <br />
text1<br />
text2<br />
text3<br />
how would I go about using those fields in one statement?
</div>


I tried the above and it gives me a parameter error.  Here is my code.

sSql1 = "UPDATE 22shop_5min SET jobnumber= " & JobNumber22 & " where [22shop_5min].id = 1"

If I had fields
text1
text2
text3
how would I go about using those fields in one statement?

<div>
Thanks so much. &nbsp;It was syntax that was getting me. &nbsp;I knew it had to be easy. &nbsp;I just couldn't see it.<br />
<br />
Great!!
</div>


Thanks so much.  It was syntax that was getting me.  I knew it had to be easy.  I just couldn't see it.

Great!!

<div>
you're welcome!<br />
-priya
</div>


<div>
<div class="content wysiwyg-content">
Here is the code I am now using. &nbsp;How would I rewrite this to update more than 1 field without writing multiple Update statements? &nbsp;I have around 30 fields to actually update in my Access Database.<br />

</div>
</div>


Here is the code I am now using.  How would I rewrite this to update more than 1 field without writing multiple Update statements?  I have around 30 fields to actually update in my Access Database.


updating more than 1 field using sql statement

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.