can we update different multiple rows of single field

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • mohinder
    New Member
    • Dec 2010
    • 3
    #1

    can we update different multiple rows of single field

    the following query is not working in ms acess, can you please help me?



    UPDATE MTO_TEST_PDTABL E_34 SET MTO_TEST_PDTABL E_34.MODEL_CODE = 'GATE_VALVE' WHERE MTO_TEST_PDTABL E_34.MODEL_CODE ='GAT' &
    SET MTO_TEST_PDTABL E_34..MODEL_COD E = 'CONC_RED' WHERE MTO_TEST_PDTABL E_34..MODEL_COD E ='REDC'
    Tags: None
    • mohinder
      New Member
      • Dec 2010
      • 3
      #2
      the following query is not working in ms acess, can you please help me?



      UPDATE MTO_TEST_PDTABL E_34 SET MTO_TEST_PDTABL E_34.MODEL_CODE = 'GATE_VALVE' WHERE MTO_TEST_PDTABL E_34.MODEL_CODE ='GAT' &
      SET MTO_TEST_PDTABL E_34..MODEL_COD E = 'CONC_RED' WHERE MTO_TEST_PDTABL E_34..MODEL_COD E ='REDC'

        Comment

        Previous template Next
        Working...