Update

  • Thread starter Thread starter Ellen
  • Start date Start date
E

Ellen

Hello,
I updated a text field with a memo field. Consequently
some entries were truncated. I have changed
that text field to a memo field. Now I'd like to rerun
that update on the truncated entries only.

Can someone write me a script that would do that? I'd
like the field, MAINTERM, of the table CEDI to
be updated from the "Chemical" field of the table NOL.

Thank you in advance,
Ellen
 
Hi

The text field has a string length of 255 so if you
create a query to find whci records have a string lenght
of 255 then these will be the records that need updating.

So to start with creat a query as follows

add the table with the converted field
then in field build the following expression
LEN([your field name]) include both bracket types
and have criteria >255 this will identify those that you
need to update
 
Hi, Colin. I wrote the following query:

UPDATE OfasLinkedNols1 INNER JOIN (CEDI INNER JOIN
NormalizedNOLs ON CEDI.[ID#] = NormalizedNOLs.NolID) ON
OfasLinkedNols1.ID = NormalizedNOLs.ID SET CEDI.MAINTERM =
OfasLinkedNols1!Additive
WHERE (((Len([OfasLinkedNols1]![Additive]))>255));

that worked. Thanks!
-----Original Message-----
Hi

The text field has a string length of 255 so if you
create a query to find whci records have a string lenght
of 255 then these will be the records that need updating.

So to start with creat a query as follows

add the table with the converted field
then in field build the following expression
LEN([your field name]) include both bracket types
and have criteria >255 this will identify those that you
need to update
-----Original Message-----
Hello,
I updated a text field with a memo field. Consequently
some entries were truncated. I have changed
that text field to a memo field. Now I'd like to rerun
that update on the truncated entries only.

Can someone write me a script that would do that? I'd
like the field, MAINTERM, of the table CEDI to
be updated from the "Chemical" field of the table NOL.

Thank you in advance,
Ellen
.
Click to expand...
.
Click to expand...
 
Back
Top