User Profile

Collapse

Profile Sidebar

Collapse
mohinder
mohinder
Last Activity: Dec 10 '10, 06:37 AM
Joined: Dec 10 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • mohinder
    replied to can we update different multiple rows of single field
    in Access
    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'
    See more | Go to post

      Leave a comment:

    • mohinder
      started a topic can we update different multiple rows of single field
      in Access

      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'
      See more | Go to post
      • mohinder
        started a topic can we update different multiple rows of single field
        in Access

        can we update different multiple rows of single field

        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'
        See more | Go to post
        No activity results to display
        Show More
        Working...