I would like to apologise to Katie, she was looking at the sequence of posts on the 2011 coursework and became confused with the “Short” data type. At the time I wrote the solution for the 2011 coursework we were using VB6, this uses the Integer data type to store whole numbers. When I created the articles in December, I opened up the original project using VB2008EE to capture the screen grabs. The import wizard unbeknownst to me had changed the data type to short. I should have noticed it but I missed it, sorry.
I’ll let the MS help do the explaining after the break.