3 Replies - 379 Views - Last Post: 25 February 2017 - 08:49 AM

#1 ltejada27  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 25-February 17

Updating a table

Posted 25 February 2017 - 08:08 AM

I need to update a table so that rows that don't have a year will be assigned the year 2013. Can someone help?
Is This A Good Question/Topic? 0
  • +

Replies To: Updating a table

#2 astonecipher  Icon User is offline

  • Too busy for this
  • member icon

Reputation: 2342
  • View blog
  • Posts: 9,393
  • Joined: 03-December 12

Re: Updating a table

Posted 25 February 2017 - 08:26 AM

Not until you show a query, but case statements work well for that.
Was This Post Helpful? 0
  • +
  • -

#3 ltejada27  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 25-February 17

Re: Updating a table

Posted 25 February 2017 - 08:42 AM

View Postastonecipher, on 25 February 2017 - 08:26 AM, said:

Not until you show a query, but case statements work well for that.



I need to update the table so that the rows that have no year will be assigned the year 2013.

View Postltejada27, on 25 February 2017 - 08:38 AM, said:

View Postastonecipher, on 25 February 2017 - 08:26 AM, said:

Not until you show a query, but case statements work well for that.



I need to update the table so that the rows that have no year will be assigned the year 2013.

Attached image(s)

  • Attached Image

Was This Post Helpful? 0
  • +
  • -

#4 astonecipher  Icon User is offline

  • Too busy for this
  • member icon

Reputation: 2342
  • View blog
  • Posts: 9,393
  • Joined: 03-December 12

Re: Updating a table

Posted 25 February 2017 - 08:49 AM

Good for you! Doesn't change the part about showing a query that you have tried to do so. If this is for excel? Format it as a table, filter the column to only show what doesn't have a year, and change them.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1