Below is a variant of boblarsons original where I incorporated the improvement of adding the "-1" suggested by another and further added the error handling. My final result shown below worked when I put it in a module in Microsoft (R) Access 2003 database and the query formats of boblarson...