Search results

I am trying to import a .txt file into an Access 2007 table. The file contains values in Euro format. How do I import them so they so as a value in US format. This is how it is in the file: 1.200,00 I want it to import as: 1,200.00 Can it be done easily. I tried changing the specs to...

Hi. I am using Access 2007 and am trying to remove the version from certain item codes. Examples of some of the item codes are listed below. The version portion I am trying to remove is -YY. V42273-Z2-A12 H50402-B509-A43 S42024-L5349-A1-YY TNX:A4B0000007988-YY I have tried to use the...