What's New

Excel Quarter Function

| |

Here’s a function that can tell you what quarter a given date falls in. It assumes that April 1st is the beginning of the fiscal year (common for government). So January to March... READ MORE

What Are Database Tables?

| |

There is a difference between a spreadsheet (which more people are familiar with) and database tables. Below is a typical spreadsheet that has generically labelled rows and columns. In contrast, below is a... READ MORE

Separating First and Last Name

| |

I did a quick blurb on how to change data programmatically in Access. This program took a full name (entered into a field called “Alias”) and separated the first and last name and... READ MORE