<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE id=ridTitle>Glacier</TITLE>
<STYLE>BODY {
MARGIN-TOP: 20px; FONT-SIZE: 10pt; MARGIN-LEFT: 50px; COLOR: #006666; FONT-FAMILY: Arial, Helvetica
}
</STYLE>
<META content="MSHTML 5.50.4930.1700" name=GENERATOR></HEAD>
<BODY id=ridBody background=cid:533524613@07102003-22bd>
<DIV><SPAN class=533524613-07102003>have you tried using an update
query??</SPAN></DIV>
<DIV><SPAN class=533524613-07102003></SPAN> </DIV>
<DIV><SPAN class=533524613-07102003>alun</SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT
face=Tahoma>-----Ursprüngliche Nachricht-----<BR><B>Von:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>Im Auftrag von </B>Paul
Rodgers<BR><B>Gesendet:</B> Dienstag, 7. Oktober 2003 15:49<BR><B>An:</B>
AccessD (E-mail)<BR><B>Betreff:</B> [AccessD] Updating a table
<BR><BR></FONT></DIV>
<DIV><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: EN-GB; mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><FONT
color=#000000>150 records are filtered from a table (tbl<SPAN
class=265294813-07102003>MyTable</SPAN>) which holds about 1500 records. 120
of them are selected by the User and now I must enter the phrase "bb3" into a
field called <SPAN class=265294813-07102003>"TheField"</SPAN> in the
table. <BR><BR>Is there a way to have a Query (or code) enter this in the
correct 120 records, please, gurus?</FONT></SPAN></DIV>
<P><FONT size=2><FONT face=Verdana><FONT color=#808000><FONT
face="Monotype Corsiva" size=4>paul</FONT><BR><BR><STRONG>Paul
Rodgers</STRONG><BR>Online Strategy and e-PR<BR>Summit Media<BR>tel. +44
(0)1788 523307<BR>fax. +44 (0)1788 523306</FONT></FONT> </FONT></P>
<P> </P></BLOCKQUOTE></BODY></HTML>