Search results

Hi, In a single table I am updating the field Route_Class. Pretty straight forward. UPDATE workingtable SET workingtable.route_class = Switch( WorkingTable.Stop_ID = '04434MAXXIS', 'MAX-04434', WorkingTable.Stop_ID = '04434MICHELIN', 'MIS-04434', WorkingTable.Stop_ID = '04434TOYO TIRE'...

Hi, Thanks for any assistance in advance. I have VB code using the DoCmd.TransferText which imports multiple files and loads the data into a table. I would like to add part of the file name as a value in a given field in the table. The table name is NS_Import2 The field name is NS_RouteFileName...

Hi, I am an avid user of MS Access; I have good Knowledge of Sql and db. I am a VBA rookie; I have achieved many changes and goals getting solved issues from Access Programmers site. Thank you for that. RP