Extracting only part of a field

[deb_dolittle]

I have a text field containing unique id numbers. I need to extract the
last two characters from each record. The length of the values differ
slightly, depending on if the data is from category A or B. I.e,
category A data has a length of 6 characters (ABC100) and category B
has 7 characters (ABC1012). I want to know if, and how, I can take the
last two characters (i.e. 00 and 12) from this field and place them in
a newly created field.

Thanks in advance

Debbie

 

[Ricter]

The control source of another textbox could be:

=Right([FieldName],2)

 

[deb_dolittle]

Got it. It took me a second to figure out how to do this. What worked
was in the query drop down menu I selected "Update Query". I put the
field I wanted to update to in the "Field" box, and entered the quote
you listed below in the "Update to" box. I replaced your text
"FieldName" with the name of the field that had the values I wanted to
extract, and ran the query. Worked like a charm. Thanks.

The control source of another textbox could be:

=Right([FieldName],2)

I have a text field containing unique id numbers. I need to extract the
last two characters from each record. The length of the values differ
slightly, depending on if the data is from category A or B. I.e,
category A data has a length of 6 characters (ABC100) and category B
has 7 characters (ABC1012). I want to know if, and how, I can take the
last two characters (i.e. 00 and 12) from this field and place them in
a newly created field.

Thanks in advance

Debbie