S
Sarah
I currently already have an update query that replaces the inches mark
(") with nothing. If I need to replace another column in a table, can
I use the same update query?
This is what I need to update....
I have data from table 1 that I am trying to join with table 2. Some
(not all) of the data from table 1 has a suffix ("SR" or "TR") at the
end of it thats not allowing it to join correctly.
How do I get rid of the "SR" and "TR"?
Example..
Table 1 has information that looks like this: KL42SR or ME42TR
I want my data to look like this: KL42 or ME42
Not all data has this ending, and so I cant just delete the last 2
characters to the right.
Is there a way to write a Replace statement that will get rid of both
"SR" and "TR"?
Replace([Table 1]!Grade,"SR","") did not work.
(") with nothing. If I need to replace another column in a table, can
I use the same update query?
This is what I need to update....
I have data from table 1 that I am trying to join with table 2. Some
(not all) of the data from table 1 has a suffix ("SR" or "TR") at the
end of it thats not allowing it to join correctly.
How do I get rid of the "SR" and "TR"?
Example..
Table 1 has information that looks like this: KL42SR or ME42TR
I want my data to look like this: KL42 or ME42
Not all data has this ending, and so I cant just delete the last 2
characters to the right.
Is there a way to write a Replace statement that will get rid of both
"SR" and "TR"?
Replace([Table 1]!Grade,"SR","") did not work.