problem with update script

• dndaughtery

  SSChampion

  Points: 11290

  More actions

  May 11, 2009 at 9:11 am

  #129878

  I am trying to perform an update in an access 2007 database but I get an error stating missing operator. What am I doing wrong?

  update HVIRanking

  set two_percent_payment = Cast((h.two_percent * c.Percent) as long)

  from HVIRanking h inner join Calcs c on h.percentilerank > c.start and h.percentilerank < c.stop c.Percent is a decimal(18,2)
  h.two_percent is a long
  two_percent_payment is a long.

• Mayank Khatri

  SSCertifiable

  Points: 7984

  More actions

  May 11, 2009 at 9:54 am

  #992253

  Have u tried statement terminator at the end of your SQL statement ";"

  i.e. UPDATE tabname SET colname = crap;

  Haven't r SQL in Access for long time, but I was just guessing this by seeing ur statement.

  Thanks