Creating Crosstab Queries in Microsoft Access

Tutorials Shared by the Internet Community

Advertisements


Creating Crosstab Queries in Microsoft Access

A Microsoft Access crosstab query presents summary information in a compact format that is similar to a spreadsheet.

Statistics

  • Total Hits - 34893

  • Total Votes - 114 votes

  • Vote Up - 51 votes

  • Vote Down - 63 votes

  • Domain - www.databasedev.co.uk

  • Category - MS Access/Query Languages

  • Submitted By - Shekhar

  • Submitted on - 2008-04-15 07:38:15

Description

A Microsoft Access crosstab query presents summary information in a compact format that is similar to a spreadsheet. These types of queries can present a large amount of summary data in a format that is usually simpler to analyse than viewing the information in a database form. Each attribute (field) in a table typically contains a category of data. A crosstab query summarizes the data from one or more of these fields that are separated into groups based on one or more fields.    More detail...


Broken  |   Tweet  |   Facebook  |     |   Save  |   Liked  |   Down

Advertisements