MICROSOFT ACCESS DEVELOPMENT
Microsoft Access String Manipulation Using Inline Functions
You can use Access' inline functions to manipulate and extract pieces of data from text fields in order to perform operations (such as sorting) on a part of the data instead of the entire field.
Subscribers: Sign-in to activate download link -- Example database containing form and code examples from this article.
Joe Stockman is an independent consultant and author in Pittsburgh, Pennsylvania. He is the author of the Access 2007 Workbook For Dummies and the co-author of the Access 2007 Bible and Access 2007 VBA Programming For Dummies. His focus has always been to make software easier to use for those new to the computer world. jcstockman@yahoo.com
Keyword Tags: Database Development, Microsoft, Microsoft Access Development, Microsoft Office Access, Programming