Working with Databases and Records
You will find the following pointers helpful to remember when you are working with databases and records.
Watch Out for Spaces. Excel is very tolerant regarding capitalization rules. However, Excel behaves differently with spaces at the end of an entry. If you don’t find any records, the filter might contain an unintended space. A space can cause problems in a record or criteria. If you are sure there are data matching the criteria but no data is returned, use a question mark or an asterisk as a wildcard to select data with trailing blanks, or use the TRIM() and CLEAN() functions (described in Chapter 8) to clean the data.
Include All Records with or without Content. To include all records with a field entry in ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
