Article ID: 304258 - View products that this article applies to.
This article was previously published under Q304258
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).
This article shows you how to create a query that returns records that have the data in a particular case (for example, uppercase, lowercase, or mixed case). For example, assume that the following data is in the table:
AddPropertyUse one of the following methods to find the data in the case that you want.
Method 1: To Find All the Records in a Field That Contain Uppercase Text
Method 2: To Find All the Records in a Field That Contain Lowercase Text
Method 3: To Find All the Records in a Field That Contain Mixed-Case Text