Using Three Different Methods for Creating Reports in Microsoft Access (Report menu, VBA, and Excel)
I briefly cover three different ways to create reports in Microsoft Access. The first is the most commonly used method, which is using the Report template based on a query. The second method is creating a blank report and using Visual Basic for Applications to create custom counts of data in text boxes. The third is linking to a Microsoft Access table from Microsoft Excel and running categorical counts using the "COUNTIF" command. Note that if you follow the instructions for the third approach, your Excel file will update each time your Access database updates.
