<div>
Thank you gustav, that works perfectly and is easy to implement!
</div>


Thank you gustav, that works perfectly and is easy to implement!

<div>
You are welcome!<br />
<br />
/gustav
</div>


<div>
<div class="content wysiwyg-content">
I have a string like this: &quot;2012-13&quot;. I want to reduce the last characters on each side of the hyphen by 1 so that it becomes 2011-12. The string represents the current payment year and is stored in a setup table. I want to be able to write a query that will allow me to enter in the criteria row payments recorded for the current payment year and the prior payment year. ie, 2012-13 and 2011-12. Can anyone provide a solution for this that I could use?
</div>
</div>


I have a string like this: "2012-13". I want to reduce the last characters on each side of the hyphen by 1 so that it becomes 2011-12. The string represents the current payment year and is stored in a setup table. I want to be able to write a query that will allow me to enter in the criteria row payments recorded for the current payment year and the prior payment year. ie, 2012-13 and 2011-12. Can anyone provide a solution for this that I could use?

Decrement last characters of a string

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.