Denver Area Access Users Group

General Meeting Presentation

Tuesday, February 7, 2017

Paul Schnitzler

Crosstab Query Tips and Tricks

Paul Schnitzler

See how to summarize data so it easier to read and understand using crosstab queries. We will start with the very basics of using the Wizard and Designer to create a simple crosstab. Then explore a half a dozen crosstab tricks and methods that you will want to know… some commonly known and 3 that are less common / more advanced. We will end with a real-life example of a review dashboard that uses a dynamic crosstab.

Paul Schnitzler if a fulltime Access & SQL Server developer serving a wide variety of business. He has over 17 year of experience with Access and SQL Server. Visit his web site at www.gearitservices.com