Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Agentilis

    SET random value in UPDATE

    Thank you PH, that worked great in isolation. Now I'm trying to put it all together in one UPDATE statement. I.E.: UPDATE Zonal SET comm_assign2 = 27 WHERE IN (2053,4206) AND (mean_elev < 1280) SET comm_assign2 = 26 WHERE IN (2053,4206) AND (mean_elev > 1730) SET comm_assign2 =...
  2. Agentilis

    newby - random in UPDATE

    silly newbies ... follow the story at: http://www.tek-tips.com/viewthread.cfm?qid=1610309&page=1
  3. Agentilis

    SET random value in UPDATE

    Trying to randomly assign values to records identified with an UPDATE statement. I know values for some conditions as in: UPDATE Zonal SET comm_assign2 = 27 WHERE (ct_code = 2053 or ct_code = 4206) AND (mean_elev < 1280) UPDATE Zonal SET comm_assign2 = 26 WHERE (ct_code = 2053 or ct_code =...
  4. Agentilis

    newby - random in UPDATE

    Seems straight forward; I'm entering this into a query in MS Access 2007: UPDATE Zonal_BaseLC_ElevAspect SET comm_assign2 = Case When mean_elev < 1280 Then 27 When mean_elev > 1730 Then 26 When mean_elev Between 1280 and 1730...
  5. Agentilis

    newby - random in UPDATE

    Thank you George, Looks great and taught me a lesson. However it returns a Syntax Error (missing operator) in query expression 'CASE When.....
  6. Agentilis

    newby - random in UPDATE

    Trying to randomly assign values to records identified with an UPDATE statement. I know values for some conditions as in: UPDATE Zonal SET comm_assign2 = 27 WHERE (ct_code = 2053 or ct_code = 4206) AND (mean_elev < 1280) UPDATE Zonal SET comm_assign2 = 26 WHERE (ct_code = 2053 or ct_code =...

Part and Inventory Search

Back
Top