remove blanks from item "numbers" in a table
UPdataed at 3:11PM
I have a table with item ID's based on this format "O35 1234 56" and I need to remove the spaces in between.
An update query would be the easiest I just cant get the positions right.
I read the following thread
http://www.access-programmers.co.uk/forums/showthread.php?threadid=12241&highlight=remove+blank
It almost solves my problem, But, my item is slightly different.
Need some help?
Thanks
UPdataed at 3:11PM
I have a table with item ID's based on this format "O35 1234 56" and I need to remove the spaces in between.
An update query would be the easiest I just cant get the positions right.
I read the following thread
http://www.access-programmers.co.uk/forums/showthread.php?threadid=12241&highlight=remove+blank
It almost solves my problem, But, my item is slightly different.
Need some help?
Thanks
Last edited: