Update

[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

 

[Colin]

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

 

[Ellen]

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
.

.