Home | Business News | Browse by Publication | S | Strategic Finance

Cross tabulate your data.

Publication: Strategic Finance
Publication Date: 01-OCT-09 		Format: Online
Delivery: Immediate Online Access
Full Article Title: Cross tabulate your data.(ACCESS)

Article Excerpt
There's a powerful summary feature in Excel called a pivot table. This feature cross tabulates data using column and row categories. The tabulation can be done for totals, counts, or averages. This is such a useful feature of Excel that people often ask me how to do pivot tables in Access. There are two ways that you can do similar cross tabulation work with your data in Access. You can create a pivot table view for a select query, or you can create a crosstab query. You also can create a pivot chart view of the select query if you want to graph your data.

Pivot Table Query View

Create a select query, and include the fields that you want to use for...

View this article FREE - Now for a Limited Time, try Goliath Business News
Free for 3 Days!



Looking for additional articles?
Search our database of over 3 million articles.

Looking for more in-depth information on this industry?
Search our complete database of Industry & Market reports by text, subject, publication name or publication date.

About Goliath
Whether you're looking for sales prospects, competitive information, company analysis or best practices in managing your organization, Goliath can help you meet your business needs.

Our extensive business information databases empower business professionals with both the breadth and depth of credible, authoritative information they need to support their business goals. Whether it be strategic planning, sales prospecting, company research or defining management best practices - Goliath is your leading source for accurate information.