Leading the way in Microsoft Office Development

Reference Articles - 2007

2007: Filter by using advanced criteria

2007: Filter data in a range or table

2007: Filter for unique values or remove duplicate values

2007: Insert subtotals in a list of data in a worksheet

2007: Reapply a filter and sort or clear a filter

2007: Remove subtotals

Reference Articles - 2003

2003: About exchanging data between Excel and Access

2003: About subtotals

2003: Add edit find and delete rows by using a data form

2003: Calculating subtotals and working with levels in Excel

2003: Copy Access data into Excel

2003: Create an Access database from an Excel workbook

2003: DELETE About data entry forms

2003: Differences between OLE DB provider and ODBC data source connections

2003: Examples of complex criteria

2003: Find a record by using a data form

2003: Five ways to subtotal values in repeating data

2003: Import Excel data to an Access database

2003: Insert subtotals in a list of data in a worksheet

2003: Office programs you can use to create a table

2003: Remove subtotals

2003: Summary functions available in PivotTable and PivotChart reports

2003: Troubleshoot exchanging data between Excel and Access

2003: Using Access or Excel to manage your data

Reference Articles - 2002

Reference Articles - 2000

2000: New ways to automate corporate reporting