Building a Copyright Database, Part 10

Progress feels slower right now, but that's because I'm having to learn VBA for Excel. Once I get this step done, this project is going to move much, much faster. Click here to read the first part of the series if you're new here. Last time, I talked about currency...

Building a Copyright Database, Part 9

I'm back on the progress train, which is a beautiful thing after where I was a few days ago. I'm humming along with getting royalties to display properly. But first, click here to read the first part of the series if you're new here. To recap from the last post, I...

Building a Copyright Database, Part 8

If the last post was lucky number seven, this post is unlucky number eight. WOW–just WOW am I amazed at how truly complicated royalty statements are. The deeper I got into this, the more I realized why no one has ever tackled this. It's time-consuming, goes...

Building a Copyright Database, Part 7

Lucky number seven, baby! I’ve got a GOOOOOD feeling about this. In this post I’ll detail out the steps I followed so that I can keep a log of what I’ve been doing to track sales and import them into the database. But before we begin: Part 1 Part 2...

Building a Copyright Database, Part 6

Today was all about loose ends and learning. I lost data somehow, so I had to rebuild a couple tables again, which was a pain, but I got it done and still had a very productive day. Fair warning that the second half of this post is a lot of text (and not as many...

Building a Copyright Database, Part 5

Today is when things REALLY started to take shape. Thank goodness I had the courage to blow things up on Day 3, and you'll see why shortly. This database is coming along SUPER nicely now, and I gained a lot of momentum today. If you're new: Part 1 Part 2 Part 3 Part 4...