Microsoft Access Query Help Center

Examples, Syntax, VBA, Errors, Tips, and Techniques for Beginners to Advanced Access Users and Developers

Here are some of our resources to help you better understand and use Microsoft Access queries across all MS Access versions:

Retrieving Records

• Microsoft Access Query Tips and Techniques (SQL and VBA) (featured on MSDN)
• Microsoft Access and SQL Server Database Normalization Tips
• Using a Microsoft Access Crosstab Query to Create Monthly Summary Reports without Code
• Difference Between "Unique Values" (SELECT DISTINCT) and "Unique Records" (SELECT DISTINCTROW) in Microsoft Access Queries
• Microsoft Access/SQL Server Not-In Query Tip: Finding Records in One Table but Not Another with Outer Join Queries
  Quickly find missing and orphaned records.
• Sorting on Multiple Date (or Numeric) Fields with Blank Values
• Microsoft Access Union vs. Union All SQL Query Syntax

Modifying Data with Queries

• Microsoft Access Append Query Examples and SQL INSERT Query Syntax
• Microsoft Access Update Query, SQL Syntax, Examples and Errors
• Microsoft Access Delete Query, SQL Syntax, Examples and Errors
• This Recordset is not updateable: Dealing with Non-Updateable Microsoft Access Queries
• Suppress Warning Messages When Running Microsoft Access Action Queries Programmatically in VBA
• Returning the Number of Records or Rows Affected by an Action Query in Microsoft Access with VB6/VBA

Numerical Analysis Beyond Microsoft Access Queries

Discover how Total Access Statistics brings advanced numerical analysis to Microsoft Access. Running as a Microsoft Access add-in, Total Access Statistics extends the power of MS Access queries with a wide range of statistical analysis including the calculations of percentiles, regressions, correlations, frequency distributions, rankings, financial cash flow analysis, moving averages and sums, t-Tests, ANOVA group analysis, Chi-square, non-parametrics, probabilities, etc. It can even perform data normalization of your "spreadsheet like" tables.

All results are in Access tables that you can query or add to your forms and reports. A statistical analysis library offers a programmatic interface to VBA developers. A royalty-free runtime distribution license is included.

Get the free trial:

Please Provide Feedback

Let us know if you like these topics and what additional issues you'd like us to cover on our Blog