Category Archives: Microsoft Access 2013

Creating a custom sort in Microsoft Access

It is easy enough to do a custom sort in Microsoft Excel, but what about in Access. In Access, you can create a calculated field using IIf in order to be able to do so. As an example, if you … Continue reading

Posted in Microsoft Access, Microsoft Access 2007, Microsoft Access 2010, Microsoft Access 2013, Microsoft Access 2016 | Tagged , | 4 Comments

Finding unmatched records in Microsoft Access

If you want to find records with no corresponding records in related tables, you can also use the Find Unmatched Query Wizard. This yields the same result as using Is Null in the QBE grid criteria. Please note however that … Continue reading

Posted in Microsoft Access, Microsoft Access 2003, Microsoft Access 2007, Microsoft Access 2010, Microsoft Access 2013, Uncategorized | Tagged , | Leave a comment

Microsoft Access – finding duplicate records

If you want to find duplicate entries in a field in a table or query, the easiest way to do this is to use the Find Duplicates Query Wizard. For example, you may wish to find records with the same … Continue reading

Posted in Microsoft Access, Microsoft Access 2003, Microsoft Access 2007, Microsoft Access 2010, Microsoft Access 2013, Microsoft Access 2016 | Tagged , | 1 Comment