I have a table in Access that contains vehicle information from a dealer.<br/> There is a stock # field and a photo URL field. The image title should match the stock #. Is there a way to make the two fields match?<br/> Here is an example:<br/> <br/> Stock #<br/> 10M020<br/> <br/> URL:<br/> http://myurl/image/12345.jpg <br/> <br/> URL SHOULD BE:<br/> http://myurl/image/10M020.jpg© 2009 Microsoft Corporation. All rights reserved.Mon, 15 Jun 2009 15:46:18 Zd85ca1b2-41d7-4533-9758-8e7a8b668f2dhttp://social.msdn.microsoft.com/Forums/en-US/MSDNPlans/thread/d85ca1b2-41d7-4533-9758-8e7a8b668f2d#d85ca1b2-41d7-4533-9758-8e7a8b668f2dhttp://social.msdn.microsoft.com/Forums/en-US/MSDNPlans/thread/d85ca1b2-41d7-4533-9758-8e7a8b668f2d#d85ca1b2-41d7-4533-9758-8e7a8b668f2ddthatsme33http://social.msdn.microsoft.com/Profile/en-US/?user=dthatsme33I have a table in Access that contains vehicle information from a dealer.<br/> There is a stock # field and a photo URL field. The image title should match the stock #. Is there a way to make the two fields match?<br/> Here is an example:<br/> <br/> Stock #<br/> 10M020<br/> <br/> URL:<br/> http://myurl/image/12345.jpg <br/> <br/> URL SHOULD BE:<br/> http://myurl/image/10M020.jpgMon, 15 Jun 2009 15:46:17 Z2009-06-15T15:46:17Z