Search results

  1. K

    Question Replacing Names with Update Query

    This shouldn't be a tough problem, but for some reason I'm stumped. I've got a huge database which has city names in it. The names themselves are outdated and I have to replace the names (e.g. Attleboro Falls is now North Attleboro). There are over 500 names to replace, so I can't do it one by...
  2. K

    Converting Column Headers to Data with Ordered Panel Data

    I've got a rather big pickle of a problem that's left me stumped. I have a giant database of some 40,000+ rows, each detailing a company. Columns in this database include employment by year (columned Emp90, Emp91, etc.), as well as sales (Sales90, Sales91, etc.). The data currently looks like...
Top Bottom