expressions 1

[dvannoy]

I have a table that has a doc# field and doc field...
The doc# field has a number like 1234567-1A....what i want to do is, create an update query that will take the doc# and strip the "-1A" from the end of the number...One of the problems is, that the doc# will never be the same lenght. Thats my problem..

Thanks

 

[LonnieJohnson]

This expression will strip the last three characters from the data in the Doc # field:

Left([YourFieldName],Len([YourFieldName])-3)

If you wish to use it in an update query, you need to put it in the Update To section of the grid.

Good luck,, ljprodev@yahoo.com
Professional Development
MS Access Applications